+4Hello 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.
Best answer by kuovonne
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.
+29Welcome 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.
+4Welcome 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.