Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

How to filter via Search Record in Integromat

Topic Labels: Formulas
1402 1
cancel
Showing results for 
Search instead for 
Did you mean: 
kennypurnomo
7 - App Architect
7 - App Architect

Hello,

I am using integromat and i want to “Search Record” based on “Parent model” and “Map years”.

So i want to achieve Parent model equals Accord AND Map years contains 2012

image

1 Reply 1

It’s the exact same formula as writing a formula in Airtable that results in anything but 0, false, "", NaN, [], or #Error!

So, your formula would look like this:

AND({Parent model}="Accord",FIND("2012",{Map Years}))