Skip to main content

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

  • March 20, 2023
  • 1 reply
  • 27 views
K
Forum|alt.badge.img

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 Attachments

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31

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

Adam, Airtable Consultant - thetimesaving.company
Terms & ConditionsAccessibility statement