Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Topic Labels: Formulas
1789 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Fahad_Sheji
6 - Interface Innovator
6 - Interface Innovator

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?

Shuyen
5 - Automation Enthusiast
5 - Automation Enthusiast

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.