Apr 05, 2021 08:57 AM
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?
Solved! Go to Solution.
Apr 05, 2021 09:06 AM
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.
Apr 05, 2021 09:06 AM
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.
Apr 05, 2021 10:17 AM
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.
Apr 05, 2021 10:35 AM
@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.
Apr 05, 2021 12:37 PM
Yes I sent an email!
Apr 05, 2021 01:03 PM
Great! :grinning_face_with_big_eyes: :raised_hands:
Jul 31, 2023 06:09 AM
This totally fixed my issue, thank you very much