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


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.


You would use the OR function:

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