Hi, I try to filter airtable using the by the record’s id, for example
filterByFormula=OR( {id} = ‘rec1’, {id} = ‘rec2’, … )
and I got the error “unknown field names: id”. That also results in errors even after I remove the brace brackets.
Tangent
+3You can only filter by fields that are present in the “fields” part of JSON object returned by the API.
Unless you have explicitly declared the field “id” in your base you can not filter by it.
+19So what you want to do is create a new formula field that uses RECORD_ID() in order to display the id. Then you can reference that field in your filter
+6openside wrote:
So what you want to do is create a new formula field that uses RECORD_ID() in order to display the id. Then you can reference that field in your filter
Really? What is the syntax? this does not work for me: fldnwAXj3iM53qu4y or this {fldnwAXj3iM53qu4y}.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.