Leading/trailing spaces in form data

Topic Labels: Automations
637 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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