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?
