Skip to main content

Their must be a way, but I am banging my head trying to figure out formula 😦



I have a form that asks for First & Last name that goes into an Airtable Grid View, which then is grouped by First & Last Name.


Problem is, when someone changes the format or accidentally adds another space when submitting a new form it gets sent to a new group.



Example - “John Doe”, " John Doe", "John Doe ", “john doe”, etc… all get sent to different groupings.



I am trying to covert all formats to “John Doe”.



Thanks for any help!



I think you need this.






I think you need this.






That is what I am looking for, but driven by a formula for instant updates so I don’t have to run script. Any suggestions? Thanks again


That is what I am looking for, but driven by a formula for instant updates so I don’t have to run script. Any suggestions? Thanks again




Scripts can now be be triggered by subtle data changes.




Reply