Sort Choice (dynamic) entries
Is there a way to sort the entries in a choice (dynamic) field? I've tried wrapping sort() around my Dynamic values selection — sort(select Category) — but that appears to have no effect. Currently, these values are showing up in the reverse order they were entered into the Category table.
8 replies
-
Hi Kevin. Try this:
--
select Category order by *
--
* Amount or Name or any field in the table you want to sort by
Fabio
-
That works! Thanks!
-
This works great but what about sorting the actual data in the grid view? For example, once the choice is selected and the record is saved, it seems that only the ID is actually saved so that if I try to sort the results, I cannot get it to sort this column alphabetically, even if I set the Dynamic value name as text('FieldName').
In summary, how do I force a column that is populated with Dynamic Choice data to sort alphabetically? -
said:
but what about sorting the actual data in the grid view?What "grid view" are you talking about?
Content aside
- 5 mths agoLast active
- 8Replies
- 491Views
-
2
Following