I’m using Zapier with Airtable and a New Record in Airtable trigger. The new record has an email address like d12345@…
Then I have a Find Record in Airtable action. There is a record with the email D12345@… - with a capital D.
The Find Record action doesn’t find anything.
Is there any way to make this work so that the Find Record action will match on similar strings like this?
Welcome to the community, @Dustin_Lange!
Yeah, from my own experiments, it seems like Airtable is very picky about capitalization.
You could create a formula field with this formula:
This would convert your email addresses to all lowercase, and then you could search on that field with all lowercase letters.