I am curious if there is a way to set default sort order for my database when in view mode. I would like to use the numbers 1-18 in a selection field, but this causes them to be sorted as strings (10 comes before 2). I’ve tried padding the numbers in the list with a leading zero, and now by default that column appear to default to Z-A sorting. Is there a way I can set the view to sort A-Z (or 1-18 in this case) by default on this selection field?
For selection fields, even if the sorting prompt says A-Z sorting or Z-A sorting. It will sort your 1-18 correctly according to its numerical order, if the choice options are purely numerical. If this is not the behavior that you’re seeing, you can send to firstname.lastname@example.org to have a support staff check your sheet out.