Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to dedupe contacts with emails without being case sensitive?

357 1
Showing results for 
Search instead for 
Did you mean: 

i just discovered that Airtable treats email addresses as case sensitive. when i tried to dedupe, it didn’t flag an identical email address because the record had been entered with different upper and lower case letters.

is there a way to force it to view the email field as “not case sensitive” so that it identifies duplicate records?

1 Reply 1

Not really much you can do with an Email-type field, but you could add a Formula field that does LOWER({Name of email field}) and use that one for deduping purposes.