Hello there,
Is there a way to automatically sort a table after I add a new record to it?
Thanks
Solved! Go to Solution.
Well, that is an entirely different question!
The order of items in a dropdown list can be sorted however you chose. If you have a list of Ref values, wrap the list with an ORDERBY() expression. For instance, to sort a list from the Related Order Details column by their row numbers in the spreadsheet:
ORDERBY([Related Order Details], [_ROWNUMBER])`
The expression is commonly used as the Valid If expression, to limit the userโs choices to only those entries in the list.
See also:
Thanks Levent. This is the way to sort a View but is there a way to sort the actual data in the Table?
Nope.
Thank you .
What Iยดm really trying to do is to sort a dropdown list that comes from a referencd table.
The dropdown values are shown in the same order as the records in the source table. Not in alphabetical order.
Then the real question is, how do I sort a dropdown lis?
Well, that is an entirely different question!
The order of items in a dropdown list can be sorted however you chose. If you have a list of Ref values, wrap the list with an ORDERBY() expression. For instance, to sort a list from the Related Order Details column by their row numbers in the spreadsheet:
ORDERBY([Related Order Details], [_ROWNUMBER])`
The expression is commonly used as the Valid If expression, to limit the userโs choices to only those entries in the list.
See also:
Success!!
Used this expression succesfully:
Thanks a lot Steve!
User | Count |
---|---|
43 | |
29 | |
22 | |
20 | |
15 |