Help

filterByFormula with selectRecordsAsync

530 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Peter_Borg
6 - Interface Innovator
6 - Interface Innovator

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

 

1 Reply 1
Peter_Borg
6 - Interface Innovator
6 - Interface Innovator

oops, it looks like @kuovonne already answered this question in this post from back in 2021. And it's a NO.