Does anyone know if I can use filterByFormula with selectRecordsAsync in a script? ChatGPT tells me I can but I'm doutful. The script editor gives me a red squiggly line, and the script doesn't work. Completes okay but does not apply the filter. e.g in the following code (assuming the syntax in variable filterFormula is correct).
Also, if this really does work, does it mean I can get around the Airtable selectRecords return limit? Or can I only do this by calling the API direct.
Grateful for any help.
let customerBookingsRecords = await customerBookingsTable.selectRecordsAsync({
fields: ["Day"],
filterByFormula: filterFormula
});
