Skip to main content

How to dedupe contacts with emails without being case sensitive?

  • June 3, 2021
  • 1 reply
  • 15 views
E
Forum|alt.badge.img+14

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

    Kamille_Parks11
    Forum|alt.badge.img+27

    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.

      Terms & ConditionsAccessibility statement