Hey guys thank in advance, I’m trying to fetch a single record base on email Address column.
- I’m using Express and Axios from the front end to parse the
req.body
request and pass it in to the select method with thefilterByFormula
option, but it seems that every time I use template literals the response brings back all values in the email column. any idea why is that. I’v tried several variation, but with no luck.
const record = await sheet.select({ filterByFormula: `"{Email} =${email}"`}).firstPage()
- plus I was wondering if I can fetch a record with the
find
method, but based on a column and the id is that possible?
cheers to all