Help

Use FIND on 2 fields

366 0
cancel
Showing results for 
Search instead for 
Did you mean: 
andyjones81
4 - Data Explorer
4 - Data Explorer

I'm trying to do a search on multiple fields I've tried the following (as well as SEARCH)

How do I do it?

async function search(term) {
  try { 
    console.log(term)
  return await base('Reviews')
    .select({filterByFormula: `FIND("${term}", {Name},"${term}", {Description})`}).firstPage()
  }catch(err){
    console.log(err)
  }
}

 

 

0 Replies 0