Convert Names to Proper Format for Grouping

[RnJ]

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!

[Bill_French]

RnJ:

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

I think you need this.

Field Tweaker - Script Block for In-place Transformations Show and tell

After importing data, it’s not uncommon to want to clean up and normalize data values, especially text fields that may have all types of inconsistencies. Unfortunately, Airtable doesn’t support in-place transformations where formulas can be applied to modify the field contents of all cells. This is where the Field Tweaker script block can help. It supports in-place text transformations including upper case, lower case, and title case modifications across all records for select fields. The scrip…

[RnJ]

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

[Bill_French]

RnJ:

but driven by a formula for instant updates so I don’t have to run script.

Scripts can now be be triggered by subtle data changes.

New beta: scripting action Scripting app

:wave: Zach here from the Airtable team. We have a new beta launching soon that may interest anyone who’s been using scripting block. With the scripting action beta, you can trigger a script to automatically run when a record enters a view in an Airtable base. For example, you can run a script when a form is submitted, or when a change is made either inside Airtable or using the Airtable API. If you’d be interested in trying out the scripting action and sharing your feedback, fill out this q…