Convert Names to Proper Format for Grouping

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

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.

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.

1 Like

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.