SEARCH in filterbyformula case sensitive

[Erin_Alter]

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?

[Kamille_Parks]

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.