Help

List view has inconsistent sorting

Topic Labels: Views
Solved
Jump to Solution
305 3
cancel
Showing results for 
Search instead for 
Did you mean: 
pico_pilot
5 - Automation Enthusiast
5 - Automation Enthusiast

pico_pilot_0-1705977116768.png

This list sorts correctly:

pico_pilot_1-1705977159009.png

why is 'b' coming after 'c' in this list (same table and list view)

pico_pilot_2-1705977207883.png

The remaining items in the list sort correctly.

Any clues?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

It's because you have an extra space before the first record in the list, but for some odd reason, Airtable chooses to never display extra spaces onscreen. This makes it very confusing/frustrating for users.

See Solution in Thread

3 Replies 3
pico_pilot
5 - Automation Enthusiast
5 - Automation Enthusiast

reversing the sort order (Z->A) has the same issue

ScottWorld
18 - Pluto
18 - Pluto

It's because you have an extra space before the first record in the list, but for some odd reason, Airtable chooses to never display extra spaces onscreen. This makes it very confusing/frustrating for users.

aha, bingo 🎯

I typically look for leading spaces but as you said, "Airtable chooses to never display extra spaces"

Thanks! 🙏