I wanted to group my table on AppSheet, but the order is customized - neither ascending nor descending.
For example, the displayed group on the left panel of my table view should be exactly
Closing This Week
Open
Past Due
Stalled
Registered
Closed Lost
The easiest way is to just prefix the values with numbers. Is that suitable?
I showed it to the users and they didn’t like it. They just wanted the texts as they are but sorted that way. @_@ I saw a tutorial about using invisible unicode characters as a replacement, but the unicode source website no longer exists. This is currently a blocker in a project that I’m working on. >_<
Ok. One solution is to create a new table for those status values. Include a numeric column that contains the ordering number. Then instead of doing a group by on a single table view, you have two table views, one on the new status table, and one showing the original table w/o grouping. You can set up these 2 views in an interactive dashboard, or you can setup a LINKTOFILTEREDVIEW action on the first view’s row click behavior to more closely mimic the original group by behavior.
I will try this unicode. I will get back to you about the result.
This doesn’t work.
Sure it does. Prefix each display name with the number of ZWSP characters corresponding to the position you want them to have (e.g. 1 for #1, 2 for #2, etc.).
FOUND A SOLUTION!
If the basis of your grouping is a column with Enum, arrange the options according to how you want users to view them. This will also apply in the grouping.
Source: UX View Options Sort By not in alphabetical order
Thanks, @Steve !
