Solved: Can I sort the data in a Ref field? - Page 2

Allan_Fullerto1 · 07-04-2019 01:30 PM

Hello, I have an app that uses a REF field to store jobs names and it allows users to add a new name if they can’t find one they want. My question is, is it possible to have Appsheet show the stored options in alphabetical order to make it easier for the users to find the job they’re looking for?

I’m trying to do it using a script in Google Sheets (where my data is stored) but this is proving difficult because the script doesn’t seem to work when the sheet is updated by Appsheet, only when it is updated manually.

Thanks in advance

Mike_A

Nothing “silly” about your question. The ValidIf select statement has to go in the ValidIf setting box, in the Column definition for the Ref column. It’s not as clear to me how your table is set up but if this col is not the key, then you have to ensure it’s set as a label. Hard to describe here, but here is a help article that describes how to do this:

View solution in original post