Help

Numbers not sorting numerically - multi-select field in Interface chart

Topic Labels: Interface Designer
1822 1
cancel
Showing results for 
Search instead for 
Did you mean: 
krysdorf
4 - Data Explorer
4 - Data Explorer

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. 

1 Reply 1
TheTimeSavingCo
17 - Neptune
17 - Neptune

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: 

Screenshot 2023-03-21 at 3.36.23 PM.png

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