Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

API filterByFormula using an "IN" function

Topic Labels: API
1060 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Turner
4 - Data Explorer
4 - Data Explorer

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”] ?

1 Reply 1

Welcome 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})
)