How to Order a Ref Dropdown || AppSheet ORDERBY()

Learn how to order your dropdown (enum / ref) fields in AppSheet.
AppSheet is a powerful no-code app development platform. At AppSheetTraining.com, we love to help smart people like you level-up their AppSheet skills and upgrade their careers.
Check Out AppSheetIQ™ - the Free and Fastest way to learn AppSheet: appsheettraining.com/learn?src...

[@bradlegassick9327]

Thx so easy when you explain it like this! Cheers

[@AlberichRheinmann]

Thanks a lot, one step of hundred thousands .... but ( with your help ) ONE STEP 🌺

[@malihazaman9944]

Thanks for these helpful videos.
I'm trying to set a date range (example: if we want to check payment received in the last 30/ 60 days, I'm trying to set a date rage filter so management can check cash inflows from their phones for a particular period). Could you please help me on this?

[@edgardocometto2051]

I was looking for that all day today.. Thank you!
One more.. If you can, I want to know how to update a value in other table, with a value I have inserted in a table. (i'm sorry about my english). Thanks

[@AppSheetTraining]

For sure!
Do you have a reference in the table you want to change the value in that references the table you want the value from? If so you would want to use a deference expression;, but if not it may be a less direct solution.

[@Chaturvedi2562]

Can we integrate grammerly with google appsheet for checking the phrases in the app

[@AppSheetTraining]

Not directly into AppSheet but maybe you could check out if there is a Grammerly Add-On for Google Sheets (if thats your database).

[@gustavo_rochaf]

Hello, how can I put a search button on this ref dropdown ?? I have too many options to choose, and its kinda messy to order, so I want to be able to search.. can you help me ?
Thank you, great videos !

[@AppSheetTraining]

Is there a sub category for the items that are in the dropdown? For an example if you had a list of car models you could have a list of car companies in a previous dropdown that filter the dropdown of models.
Or if its a list of projects you can have a dropdown before that filters by client. so on

[@gustavo_rochaf]

@@AppSheetTraining I actually figured it out. I wanted just a search button, but it wasnt showing because my database didnt have enough items lol. It took me long hours to figure it out 🤦‍♂️

[@alexlotion5055]

Formula doesn't work with tables, consisting non english letters in the name. Is there a way to get around that restraint. Also what if the name consists of different symbols and spaces?

[@makaniharesh1459]

same thing I want to know...

[@T5Tupdates]

Nice

[@AppSheetTraining]

Thanks: :)

[@krishbosamia5166]

I want to reorder the list to :
Last items being entered should appear at the top, like last entered shown first. How do i do it?

[@AppSheetTraining]

Do you have a column that is a date/time stamp for when the row was created.
Because that will be your column used in your ORDERBY(). Then Descending TRUE= Reverse Chronological.

[@AppSheetTraining]

ORDERBY(list,[datetimecreated],TRUE)

[@krishbosamia5166]

Thanks. Worked as I wanted it to.

[@AppSheetTraining]

Glad to hear!