How to use API quety for look into multiple colum values

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”

I have tried this like and it returned nothing

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

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.