I’m having a little trouble with a script I’m using to update a date field in Airtable with data from an API. The API I’m using gives date/time info most of the time. Every once in a while it’ll output a string like “UNKNOWN,” which brings the whole ...
I’m running a scripting app that loops through all the records in my Airtable using await table.updateRecordAsync() in a few fields, including a single-select field. Every once in a while, through human error or something else, we’ll wind up passing ...
Hi there, I’d like to create an automation that, when triggered manually, appends all records that match certain conditions to a Google Sheet (that I then apply built-in formulas to in the sheet).
My first attempt was to choose the trigger “When reco...
Hi there, I work for a prison education nonprofit that works with people facing federal crimes. We want to be able to send legal updates and resources to graduates of our classes, and use Airtable to track those graduates. We want to keep our records...
Thank you! This is a good workaround for my specific case, but I imagine someone else might still want to test data for validity in a specific column type in Airtable more generally. If that’s just redundant to a collection of vanilla JS functions (a...
Well, that’s helpful for pinpointing the error, but I already know what the error is coming from, and it still halts the script. It’s possible I’m doing it wrong, I am definitely a beginner with JS.
I’ll give you more specific info, that might clarif...
Never mind. It wasn’t running but I tried erasing and re-writing it and it works fine now. Must’ve been a misplaced bracket or something somewhere. You’re right, that error tooltip is still present, but the script now seems to work. Thanks for your h...
Thanks! Would I need to declare a Promise or something before putting something like this in, or is that implied? I’m not familiar with the promise-then-catch syntax
Thanks, I tried this, but I’m getting a type error:
Argument of type ‘string’ is not assignable to parameter of type '“Alderson FPC” | “Aliceville FCI” | “Allenwood Low FCI” |…
My constants are set up like so:
const knownPrisonsField = table.getFie...
