Skip to main content

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.

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.

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.


OO of course. It worked when I switched it to OR. Thanks for the help!

Reply


Terms & Conditions