Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Additional spaces in a cell are removed automatically

Topic Labels: Base design
1232 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Jan_Dingemans1
4 - Data Explorer
4 - Data Explorer

I need to enter a record with additional spaces in a text string of a column (single line text) . Whenever I add the text string ‘a b’, the system sets the text string to ‘a b’. How can I prevent that spaces are being removed.

Thanks

Jan

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @Jan_Dingemans1!

Wow, that’s a very interesting bug you’ve discovered there!

Welcome to the Wild West of using Airtable! 🤪🤠

Any preceding & trailing spaces in a text field are actually still there within the field itself, but they are no longer visually presented to you as soon as you exit the field.

When you go back into the field, the spaces return. But when you leave the field, all the leading & trailing spaces disappear.

Same thing with a formula field.

I can see how this could be extremely problematic for people, especially if they’re trying to maintain visual integrity & consistency of data.

I would report this bug to support@airtable.com and refer them to this thread. And please report back here with what they tell you!

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

ScottWorld
18 - Pluto
18 - Pluto

I can confirm that on the Mac, this bug affects:

  • Safari web browser
  • Chrome web browser
  • Airtable app for macOS

However, surprisingly, this bug does not affect the iOS mobile app! So this works as expected in the mobile app!

- ScottWorld, Expert Airtable Consultant

pdxbug
6 - Interface Innovator
6 - Interface Innovator

Is there a solution for this? I need two spaces if I type two spaces...