Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 14, 2022 04:08 AM
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?
Oct 21, 2022 12:31 AM
What if you created a formula field and used LOWER({Email})
and used the value of that field instead?
Dec 04, 2022 03:27 AM
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.