Hi Guys
How do I go about sorting this Enumlist column type ascending correctly within a view group as well as quick edit and form drop down list.
It only seems to be possible in a Enum column type.
1 Like
How is your EnumList column configured? Hard-coded choice list or expression to pull values from another table? Settings for other values? etc.
If it is a hard-coded list directly in the column, then simply arrange the items in the order you want. See images below for example
If you are pulling your values from a table, then you would need to use either SORT(), if just a straight list of values, or ORDERBY() if it is a list of Ref values but you want to sort it by a different column.
Also, be aware that if you have the “Auto-complete other values” turned on AND there are values inserted that are NOT part of the initial choice list, you will NOT be able get this list fully sorted. AppSheet first lists all of the choice values based on the column configuration and then tacks on the “Other values” that are not included in the initial list. If this is not the behavior you want, then you will need to turn off “Auto-complete other values” and implement the adding of values in another way.
Initial entry of EnumList values
Reordered list of EnumList values
It is a pulling for the existing column of the table with “Auto-complete other values” selected.
It is really pitty that proper sorting within Enumlist
I decided to took your advice and adding in some of the values as hard coded. Notice how the Desktop environment handles sort differently from the mobile experience.
There also seems to be a few other bugs on how Appsheet manages Enumlist in general that I have referred to in the following posts.
1 Like
One pretty dirty “hack” I found with this that seems to work (assuming it doesn’t mess up the design of your app) is to add leading spaces to the values to get them in the order you want. It uses those leading spaces to sort, but trims them out in displaying in the left panel, so you can end up with the result you want there.