filterByFormula array contains


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

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

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


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


You might find what you’re looking for here: