- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 20, 2023 08:59 AM
I'm using a multi-select field to capture grade levels taught (Pre-K - 12th) and added this data into a chart in an Interface.
When sorting Ascending or Descending (the only options), the logic of the sort seems to be treating the numbers as single digits and sorting them based on the first digit. (ie: "10" is read as "1" then "0")
Is there a way to get this to display grades 1-12 in order? A similar post questioned if this was a bug....and surely it is some type of logical but sorting numerically seems quite basic.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 21, 2023 12:37 AM - edited ‎Mar 21, 2023 12:40 AM
Unfortunately no, with a multi-select field you're automatically stuck sorting it alphabetically and not numerically I'm afraid
The (ugly) workaround I end up using is putting an invisible character in front of stuff so that it looks right: 
And so the "1" that you see there is actually "‎ 1". Note that I'm using an invisible character and not a space
Link to base
