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)
}
}