Jun 01, 2020 09:25 AM
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?
Jun 02, 2020 09:18 PM
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?
Jun 02, 2020 10:13 PM
Like a lookup formula in the encoded url? I wasn’t aware I could do that with this API. All of the data is being added, deleted, and modified remotely through the API instead of direct table changes from Airtable’s UI
Jun 02, 2020 10:35 PM
Actually what i meant is that instead of having the record as Linked record (so it will return a Record ID, not the actual Array), you can use this same record to add a Lookup Field, then the data will be in the form of an Array and you can search it up.
Jun 02, 2020 11:34 PM
Also, you can simply add a formula field (instead of the Lookup field I suggested) and make it equals to the Linked Field. This will also return the data as an Array and you can search it.
Jun 06, 2020 07:50 PM
@Mohamed_Swellam This is a question about API functionality.
@Kawika_Buttel Your question ended up in the wrong category (Formulas). I’m moving it to the proper category to discuss API-related concerns.
Jun 07, 2020 06:11 AM
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.