Find record regardless of text case

[pascalm]

I've created an automation to link the submissions of two forms together based on the email a customer inputs. Presuming that they input the correct email in both forms without typos, it will link them no problem.

I've just noticed today that if one email is all lower case and one has an uppercase letter then it won't connect the two even though it's spelt exactly the same.

I understand there are formulae that I can use to correct the case, but I want to manage this through the automations. Is there a way to create a find record condition that is "Where *email address* is *email address*" that isn't case sensitive?

[Chris_Luc · Accepted solution]

Easiest way would be to change the record condition to "Where *email address* CONTAINS *email address*" instead of IS. 'Contains' is not case sensitive.

Or if you're sending the form out via an automation, you could prefill the email address field. Instructions here: https://support.airtable.com/docs/prefilling-a-form-via-encoded-url

[pascalm]

Thanks @Chris_Luc! I didn't know that 'contains' wasn't case sensitive. I changed it and it works fine.

Great idea about the pre-fill too, I'll look into that.