Hi - I have a newbie question here. I am writing a script with the script block to write a value into a single select field but I keep bashing my head against the wall. Can someone give me some guidance? Here’s the short and skinny: If I use the be...
I’m creating an automation to run when a record is updated like this: " In the script, how can I get the record that was updated or its ID? So I can target only it. The example I’ve found select all records: // Update all the records let result = awa...
My question as below: I use this script: Let attachment = await input.fileAsync('Pls upload the cargo packing list') Then I want to create a new record with one field as MultipleAttachment. I want this MultipleAttachment field having the attachment...
Hi Guys, Wondering if anyone can help me out with this one. I want to create a script that incorporates an API to weather.com. The script will draw the information from the field and the field in Airtable and the result will be the weather forecast...
I am looking to Run a script in an Action. basically whenever the Category “Done” or “Postpone” is set to the record by single select field. I like to run a script that deletes those records. The trigger is pretty much easy to do by the automation co...
Explainer Video: Base: Airtable Same Table Backlinks - Airtable Universe Title: Same Table Backlinks License: MIT Author: Openside (Team behind On2Air products and BuiltOnAir c...
Here is a script that will count records per table and output the result as a little CSV output. It is a little quick and dirty and will take ‘some time’ to run if you have large record counts. Hope it is useful to someone. let tableCount = base.tabl...
Hi everyone, I have a main base, I want whenever I create new record in main base, the other specified base will be updated, and whenever I edit or create new record in that specified base, the main base also be updated. It looks like sync but I want...
Hi everyone ! I am trying to authenticate a request using Basic Auth. I then need to base64-encode my logins. (could encode them manually and then insert but would prefer to keep that logic in the code) I didn’t found how to achieve this “natively” w...
I have a task that requires itertools. but I am having no luck. is it possible to import from itertools? or any other library for that matter? thanks
I am trying to use createrecordsasync but am getting this error: “No overload matches this call” All the parameter types are correct. I’ve switched them, created variables, double checked, etc. What else can I check? No overload matches this call. T...
I’m trying to generate reports based around values stored in a single select field. I’ve tried to get access to all the valued stored in a single select field, however I’ve not had any luck getting access. Does anyone know if this is possible without...
I should make a GET request with body (I know, it’s strange, but this is what I have to do). Here below my script: let inputConfig = input.config(); let deliveryNote = inputConfig.deliveryNote; // array let courier = inputConfig.corriere; //...
Hi, Could someone demo this script showing how to properly create the parent/child and template tabs to utilize this script? I am having difficulty getting it to properly work. Thanks.
I’m pretty new to JS, but trying to learning all the time. Some of the first code I wrote in the scripting blog has gotten supper hard to update, so thought to experiment to write small modules to keep divide up the code. However it seems I can’t put...
Hi everyone! We’re excited to announce a new beta feature for the scripting block: script settings! With script settings, you can define settings for your script: a title, description, and settings items (table, field, view, text, number, and select)...
Hey, I’m a newbie with JavaScript so this might be obvious … I need a delay(ms) method to slow down the script after 5 API calls (limit 5/min.). Problem is all the JavaScript help on the intertube points to the setTimeout() method of the Window obje...
I am trying to run a script on a record update, but when I look in the Run History, all the trials end up in the “In progress… Step pending…” state. Did anyone ran into a similar problem? The script I am using is a simple fetch to Integromat Webhook....
I’ve been trying to access the symbol of a currency field. However with no luck as my output returns undefined. I’ve been looking in the API reference and it seems the the field has who properties, symbol and precision. But how do I access the symbol...
If you’re using a rollup field to summarize linked records with ARRAYJOIN(), the array’s order is determined by the order of the linked records. I created this script to automatically sort linked records in a cell. My use-case is to summarize interac...
