Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Sorting mixture of numbers and letters

Topic Labels: Sync
208 1
Showing results for 
Search instead for 
Did you mean: 

How does AT sort (address) numbers that also have a suffix letter? For example, 2A, 2B, etc.

To overcome the sorting problem for addresses in a Filemaker desktop database I use, I have a separate field alongside the address number in which I enter the address number in numerical formal only and use that separate field for sorting. For example, 2.1, 2,2, etc.


1 Reply 1

Answered my own question. AT sorts 2, 2B, 2A, 2C as 2, 2A, 2B, 2C.
so no need for separate field.