If you do a lot of importing/exporting of CSV or Excel data with Airtable, you know that invisible leading or trailing whitespace can wreak havoc on your work, especially when you try to use text data from outside Airtable to match existing single-/multi-select fields or link fields. I’ve spent many hours tracking down these kinds of errors with imported data. While you can use TRIM formulas and the like outside of Airtable to clean the data beforehand, that’s not always convenient if you don’t control the source of the data (or that data changes frequently). What about an option on single line text fields in Airtable to automatically trim leading/trailing whitespace characters once the user is done editing the field? Seems like it would save a lot of headaches and would be easy to implement.
I totally agree that this would be an incredibly valuable feature to have!
Particularly because Airtable doesn’t even visually show you if you have a leading space in your fields when you leave the field! This is extremely problematic for our clients, because you can’t even visually see when you have a problem in a field — unless you actually click into the field.
(It is unfortunate that Airtable overlooks many small details like this throughout the product, which can sometimes make it a challenging tool for my clients to use for important business tasks.)
For others reading this thread:
(Note that I am an Airtable consultant and a Registered Integromat Partner, and that link contains my personal referral code.)