Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to put a condition in a email field to lower case all the data

Topic Labels: Formulas
365 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey everyone,

I’ve been doing a couple of automation with Airtable and I use a formula to pull in data, this is the formula I use for it.

"input.email"={Email}

I use that to pull in any record on Airtable that has the email I am inputting, what I realized is, it doesn’t work when the casing is different

i.e. I noticed john@gmail.com is not equal to John@gmail.com, so the formula will say nothing found although the same email exists with just an upper case.

So I have 2 solutions in mind, lowercase all the emails in the Airtable email field cause the input data is always lowercase, or tell the formula to take in upper cased similar emails as well.

Could anyone here help me with it?

2 Replies 2

What if you created a formula field and used LOWER({Email}) and used the value of that field instead?

I also found this to be annoying, it would be great if there was a workaround where the Email field itself forces all lowercase and doesn't create a new record.