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
Jun 20, 2021 11:55 PM
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
Jun 21, 2021 05:28 AM
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}))