Dynamic Choice "order by Id" gives incorrect order
I'm trying to use a Dynamic Choice field for the first time. My "Dynamic Values" formula selects values from another table and uses the "order by" statement to sort the values by the table's standard "Id" field:
(select 'Status_List')['Status' = "Active"] order by Id
Instead of the values being ordered by "1, 2, 3, 4 ... 9, 10, 11, 12", I'm getting "1, 10, 11, 12, 3, 4...". It seems to be sorting based on the 1st digit, rather in proper numeric order.
Anyone experienced this before?
6 replies
-
Is Id a specially created text field?
Then it is also sorted like a text field.
order by number(Id) should work
-
You don't need to order by Id. Ninox does that by default.
-
All systems will order text fields in this way, even Excel. The data is seen as alphabetic and sorted accordingly. To get a true numeric order you need to convert to a number field.
Content aside
- 2 yrs agoLast active
- 6Replies
- 152Views
-
4
Following