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!