How to dedupe contacts with emails without being case sensitive?

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?

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.

3 Likes

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