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!