I’m trying to submit a url query with a filterByFormula to return only dealerships that have the specific brand in them. The brand side is linked, so it’s in a list on the return response and it’s by record ID. How do I build a filterByFormula that will look into a list instead of just the 2nd level value within fields?
Welcome to Airtable Community! :slightly_smiling_face:
How about you use a Lookup field (or a Rollup field, based in which works better for you) to bring the data to this table?
When using filterByFormula in the Standard REST API, I usually create the formula as a formula field in the user interface first. Once I get the formula field to work to my satisfaction, I port it exactly to the code, only substituting in variable names. At runtime, the filterByFormula string should exactly match the formula field.