Peter_Borg - profile

Peter_Borg · Sep 12, 2023

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 ...

Peter_Borg · Feb 12, 2023

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...

Peter_Borg · Oct 26, 2022

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...

Peter_Borg · Mar 31, 2022

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,...

Peter_Borg · May 17, 2021

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...

Peter_Borg · Sep 12, 2023

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

Peter_Borg · Sep 11, 2023

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...

Peter_Borg · Feb 19, 2023

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...

Peter_Borg · Oct 27, 2022

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...

Peter_Borg · Oct 27, 2022

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...

User Statistics

User Activity

filterByFormula with selectRecordsAsync

API Deprecation confusion

Changes to date handling in scripts

Unable to set up LOB Address Cleanser app

Google Map app fundamentals

Re: filterByFormula with selectRecordsAsync

Re: API Deprecation confusion

Re: API Deprecation confusion

Re: Changes to date handling in scripts

Re: Changes to date handling in scripts