Additional spaces in a cell are removed automatically

[Jan_Dingemans1]

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

[ScottWorld]

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! :crazy_face: :cowboy_hat_face:

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!

[ScottWorld]

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!

@Adam_Minich