Can I sort a table after adding a new record?

Hello there,
Is there a way to automatically sort a table after I add a new record to it?
Thanks

Solved Solved
0 6 262
  • UX
1 ACCEPTED 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:


View solution in original post

6 REPLIES 6

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!

Top Labels in this Space