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 ...
I created a new token and tried to use it to replace my API key in a Zapier app connection for Airtable. Thought I was doing the right thing in preparation for the deprecation in 2024. It didn't work. Zapier doesn't seem to recognise the token and wo...
A few months ago I received an email from product@mail.airtable.com descibing changes to handling of dates and timezones in scripting. Do I recall correctly? Can someone point me to the info it described?
I’m still doing manual timezone adjustments i...
Has anyone successfully set up the app “Address Cleanser by LOB”, from lob.com?
I cannot get past the setup stage. When I submit the last of my setup details (page 2 of 2) I get the message “Sorry, an error occurred”. It recommends reloading the app,...
I have a large number of properties in a table (~3000) and am using the Map App to display their locations. When I open the app, I get a very long delay (as it plots each property?). A display top right of the map shows me how many remaining, with th...
I received this email today from Zapier. Can anyone explain what this means in plain english? I always like to see "no action required" but how can that be true in this case? Does this mean Zapier is going to replace all existing API connections with...
Thanks for your response Adam @TheTimeSavingCo I'm surprised there isn't more discussion about this in the community. Maybe it will ramp up now that "Notice of Airtable API Key Deprecation" email has gone out. I'm immediately getting queries from cur...
Yep, here’s the 2 alternatives.
CONSOLE.LOG
Thu Oct 27 2022 19:04:00 GMT+1100 (AEDT)
CONSOLE.LOG
“2022-10-27T08:04:00.000Z”
The second is the actual cell value. But it doesn’t show timezone, which was my original concern. I’m thinking the developer...
Thanks @kuvonne still a little confused though I solved my problem by working out the offset in the base and reading that into the script for use.
Meanwhile when I tested out this script it displayed the date in GMt+11 (where I am). Did the same whet...
