Skip to main content

I am new to airtable.

I can’t find a way to write following query in airtable using filter by formula.


Select * from tablename where bertha={varibale1} And berthw= {variable2}


I have the 2 variable in my hand and i have the fieldname too

But in search table contain ids not direct values

Means

BerthA table id]

Berth B table eid]

So direct matching is not possible.

Anyone please help me to search a value inside the array.


I did OR( ${berthA} = ’ xxx’)

Doesn’t return anything because berthA is array

Welcome to the Airtable community!


Are you using the Standard REST API? (“filterByFormula” is a feature of the Standard REST API, whereas “formulas” usually refer to a formula field within a table.


In Airtable, building queries works very differently from building queries in other relational databases. As you’ve discovered, linked records are stored as arrays of record ids. However, if you use the “filterByFormula” parameter, it should work exactly as it works in the user interface. You should be able to build your formula in a formula field, and once it works, copy the formula exactly (substituting variable names as necessary).


If you would like additional help, can you post screen captures of your base and some code samples so that we can better understand your situation?

Reply


Terms & Conditions