Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Leading/trailing spaces in form data

Topic Labels: Automations
342 0
Showing results for 
Search instead for 
Did you mean: 

I’ve got some form data coming into a table, and I’m then using those fields from newly created records to search for corresponding records in another table. I was mystified why the automation was sometimes bombing, but I’ve determined that stray trailing blank spaces are passed by the form, and will cause a string match to fail. I realize I could add a formula field to then ‘TRIM’ all of these strings coming in from the form, but gosh that’s kinda sucky to create duplicate formula fields for everything.

Is there a better approach that I’m not aware of?

0 Replies 0