Skip to main content

How to use API quety for look into multiple colum values

  • September 7, 2022
  • 2 replies
  • 14 views

Forum|alt.badge.img+3

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

Forum|alt.badge.img+3
  • Author
  • Inspiring
  • September 7, 2022

I have tried this like and it returned nothing

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


Forum|alt.badge.img+3
  • Author
  • Inspiring
  • September 7, 2022

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