Help in filter by formula

Topic Labels: Formulas
1330 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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
BerthA table [ id]
Berth B table [id]
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

1 Reply 1

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?