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
Showing results for 
Search instead for 
Did you mean: 
7 - App Architect
7 - App Architect


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


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}))