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.
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 firstname.lastname@example.org 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?