Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to dedupe contacts with emails without being case sensitive?

1278 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Erin_Alter
7 - App Architect
7 - App Architect

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.