Alphabetically Sort a Ref List
I have a Company Records table, Company Trades table and Trades Table. They all have unique ID columns CompanyRecordsID, CompanyTradesID and TradesID.
Data entry sequence is:-
(1) Add new company (2) Assign trades to company (available trades are sourced from Trades table)
All works fine except when I want to assign a new trade to a company the ref list displayed from Trades is in the order the records were added to Trades which makes little sense so I would like them to appear alphabetically. Is there anyway of doing this?
My Trades table is very simple and only has two columns namely TradeID (key) and Trade (label) . I want to alphabetically sort the ref list display based on the Trade column. To date the only way I can do this is to sort the data in the actual source data table. This is not a workable solution as users will be free to add Trades via AppSheet so I cannot maintain the source data.
Any ideas please?
Hi @Suvrutt_Gurjar used your expression above in the form substituting actual column names as
=ORDERBY(Trades[TradesID], [Trade], FALSE)
Problem resolved - thank you for your help.
Hi @StudentHomes_Plymout, You may wish to enter the following expression in the reference columnโ s valid_if constraint
=ORDERBY(Trades Table Name[Trade Table Key Column Name], [Trades Label Column Name], FALSE)
User | Count |
---|---|
43 | |
29 | |
23 | |
20 | |
13 |