About DMiles

DMiles · 12-10-2022

I am working on an employee database and I want to have a field which identifies who someone's line manager is. Example, Bob is Charlie's line manager.Both Bob & Charlie are in the Employees table, and there is a field Is a line manager where Bob is ...

DMiles · 11-20-2022

I know how to hide a field before a record has been created, but now I want to hide a field only when the record is being edited.Reason being - It is a [Feedback Sent] field, and I only want it to be seen in the summary view, but I don't want to caus...

DMiles · 11-09-2022

I have an EnumList field containing numerical ids (e.g. 1,3,6,10)These ideas correspond to text statements in another table.I can successfully pull out the statements, but I'd like them to output one to a line.E.g. Instead of Statement 1, Statement 3...

DMiles · 10-22-2022

I have lists of values, e.g. 1, 2, 3, 6, or 12 , 14 , 15 , 16 , 17 , 20 in a columnI need to pull the corresponding statements.One example of the formula is [InstructionalDelivery][Criterion]Instead of pulling responses 1, 2, 3, 6 it is returning the...

DMiles · 10-21-2022

I'm trying to setup an attachment template.I have a table WalkthroughRecords, which has a column Assessment_of_for_learning, which is configured as EnumList because it can take multiple entries.The entries come from the Criteria table, which has the ...

DMiles · 12-11-2022

I've run into what seems to be an error - I can't use Virtual Columns as row labels when working from a database. I've been experimenting with converting an app from a sheets base to a database, but the need to have the row label be [Full name] which...

DMiles · 12-11-2022

Thank you, I had to use the Select option and build in the filter there, as opposed to trying to pull from a slice.However, although it is working and accepting the values, I still have a yellow warning triangle against each entry. Not sure why?

DMiles · 11-20-2022

So, I had to use <> as opposed to = but yes, this worked perfectly, thank you!

DMiles · 11-13-2022

Found this, solved the problemhttps://www.googlecloudcommunity.com/gc/Tips-Tricks/Current-User-Slice-How-to-conform-your-app-around-WHO-is-using/m-p/347947

DMiles · 11-13-2022

Is it possible to pull the authorisation from a table? In my staff details table I have a Leadership column, I want to authorise the view if there is a Yes next to their email address in the Leadership column?I've triedAND(IN(useremail(),StaffDetails...

My Stats

DMiles's Bio

Badges DMiles Earned

Recent Activity

Filtering to a list from the same table?

Hide a field only when editing record

Output text list in columns in a G-Doc template

Pulling the wrong data

Pulling data into a template

Re: Introducing new AppSheet database feature in public preview

Re: Filtering to a list from the same table?

Re: Hide a field only when editing record

Re: UX view show IF list of Authorized users Expression

Re: UX view show IF list of Authorized users Expression