Help

How to use API quety for look into multiple colum values

Topic Labels: Formulas
1505 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Still-Learning
5 - Automation Enthusiast
5 - Automation Enthusiast

Screenshot_2022-09-07-13-08-02-01

Friends how cam get the row values which are matches with colA values using api query

Eg, i wamt the values of field11,field51,field61

For single i use this formula
filterByFormula={colA}=“field11”

2 Replies 2
Still-Learning
5 - Automation Enthusiast
5 - Automation Enthusiast

I have tried this like and it returned nothing

filterByFormula=AND(SEARCH(%22field1181%22,{colA}),SEARCH(%22field1182%22,{colA}))

Still-Learning
5 - Automation Enthusiast
5 - Automation Enthusiast

Feel so sad with community… Either my wish is possible or not possible, nobody’s are ready to share their best experience. I am not good much with airtable so created this topic but still no users r ready to share their best experience