Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Equivalent of 'WHERE field in (value1, value2, value3)' with Airtable API

Topic Labels: API
1339 1
Showing results for 
Search instead for 
Did you mean: 

Hi I have come across the need of filtering records based on a field’s value in a defined list of values, this is equivalent to SQL WHERE clause like WHERE field IN (value1, value2, value3), so I wonder how I achieve this with Airtable API.

1 Reply 1

You would use the OR function:

OR(field = value1, field = value2, field = value3 )