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
Oct 07, 2022 01:09 PM
Hello I’m trying to query one of my tables and only return a list of records based on a list of record IDs. How would I write the filterByFomula
query?
I tried to join a series of queries like
filterByFormula=(AND((_id%3D'{{record_id_1}}'),(_id%3D'{{record_id_2}}')))
However this didn’t work.
Solved! Go to Solution.
Oct 07, 2022 01:21 PM
Welcome to the Airtable community forums!
Try writing the formula in an Airtable formula field to test it out. You will need to use OR()
instead of AND()
. You will also need a different formula field that reveals the record ID of each record.
Oct 07, 2022 01:21 PM
Welcome to the Airtable community forums!
Try writing the formula in an Airtable formula field to test it out. You will need to use OR()
instead of AND()
. You will also need a different formula field that reveals the record ID of each record.
Oct 07, 2022 01:26 PM
OO of course. It worked when I switched it to OR. Thanks for the help!