Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

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

2072 0
Showing results for 
Search instead for 
Did you mean: 
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
18 - Pluto
18 - Pluto

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