
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 03, 2021 01:38 PM
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

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 03, 2021 01:46 PM
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.
Reply
