How to dedupe contacts with emails without being case sensitive?

884 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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.