Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Zapier: Find Record in Airtable without an exact match?

490 3
Showing results for 
Search instead for 
Did you mean: 

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?

3 Replies 3

I contacted Zapier and they informed me this is a limitation of Airtable. Airtable only allows exact match searches at this time.

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:

LOWER({Email Address})

This would convert your email addresses to all lowercase, and then you could search on that field with all lowercase letters.

Thanks, Scott. That works great. I also used Formatter by Zapier to convert the original string to lowercase.