filterByFormula array contains


#1

I would like to filterByFormula the records with arrays that contain a certain ID. The arrays look something like this:

Arr
[a, b, c, d]
[c, d]
[a]

How does one filterByFormula to get all the records with arrays containing ‘a’?


#2

Does anyone have a solution for this? I am stuck with the exact same problem. Thank you.


#3

You might find what you’re looking for here: https://community.airtable.com/t/filtering-rollup-fields-through-the-api