Is there a way to filterByFormula with an “IN” type of function. I.e. only return rows where the state field value is in the list [“OR”, “CA”, “FL”] ?
API filterByFormula using an "IN" function
+29Welcome to the Airtable community forums!
The filterByFormula in the API works the same way as filtering in the user interface. You cannot use a simple IN function in your formula, because Airtable does not have such a formula function.
However, you can build a formula that has the effect that you want.
OR(
FIND("OR", {field name}),
FIND("CA", {field name}),
FIND("FL", {field name})
)
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.