Help

Convert Names to Proper Format for Grouping

1962 3
cancel
Showing results for 
Search instead for 
Did you mean: 
RnJ
8 - Airtable Astronomer
8 - Airtable Astronomer

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!

3 Replies 3

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.