Help

Sorting Single line text not working

Solved
Jump to Solution
2674 6
cancel
Showing results for 
Search instead for 
Did you mean: 
milktea
5 - Automation Enthusiast
5 - Automation Enthusiast

I am sorting alphabetically the Primary Field which is a Single line text. It does not work. I have some data for this Primary Field that are duplicates and when I sort it, it should be right next to each other but it’s not.

How can I fix this?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @milktea!

This issue could be caused by extra spaces within the text of the field.

Unfortunately, Airtable truncates all extra spaces in a field so you can’t visually see them, even though the extra spaces are there.

This is a huge bug in Airtable which they have never fixed.

Check to see if this is the problem affecting you as well: Double-click into one of your text fields that isn’t sorting properly, and see if the extra spaces suddenly appear.

See Solution in Thread

6 Replies 6
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @milktea!

This issue could be caused by extra spaces within the text of the field.

Unfortunately, Airtable truncates all extra spaces in a field so you can’t visually see them, even though the extra spaces are there.

This is a huge bug in Airtable which they have never fixed.

Check to see if this is the problem affecting you as well: Double-click into one of your text fields that isn’t sorting properly, and see if the extra spaces suddenly appear.

milktea
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks! I tried playing around with adding a space in the beginning and removing it and that fixed it.

I’ll be careful with copying and pasting data in since this is how it first started.

@milktea Great! If you don’t mind, can you please send a quick email to support@airtable.com to tell them about this issue that you had, and to request that they please display ALL SPACES onscreen at all times? If people can’t visually see their extra spaces onscreen, then they can’t figure out problems like this when they arise.

milktea
5 - Automation Enthusiast
5 - Automation Enthusiast

Yes I sent an email!

Great! :grinning_face_with_big_eyes: :raised_hands:

Ashanti1922
5 - Automation Enthusiast
5 - Automation Enthusiast

This totally fixed my issue, thank you very much