
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
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.