Can't get it to filter through the list in my linked records

Hi @Kawika_Buttel,

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?

BR,
Mo

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

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.

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.

@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.

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.