Automations: Scripting Actions Error

The Scripting Block in Airtable runs the JavaScript code in your browser, using your system resources (processor / ram) to do the processing. This is why the Scripting Block requires Airtable to be open and running on your machine to be used. Because of this, Airtable doesn’t care as much how big your scripts are or how much processing time they take up. It doesn’t cost them anything if your Scripting Block script is running for 5 minutes and hogging up tons of system resources.

The Scripting Action in the Automations feature, however, runs on Airtable’s server resources – which is why they are capable of being run even if there are no instances of your Airtable base open at the time.This costs Airtable money in server resources every time your script runs. Thus, understandably, they put a cap on how much processor time your Scripting Action scripts can use, and that cap is 1000ms.

Depending on what you are trying to do with your script, and just how far over that 1000ms the current script extends, you may have a couple options for approaching this.

1. Try to improve the script’s efficiency

   • I’d go this route first. Being that you are a novice, it’s very possible, if not likely, that there are aspects of your script which could be written to process more efficiently, and use less CPU time to do the same job. I’m not being condescending as I’m in the same boat – I am frequently finding or being shown ways that my JavaScript can be made more efficient
   • Things to look out for: nested loops; operations on one record at a time out of a collection that could be grouped together into a single operation; repetitive queries; queries inside of loops

2. Break the operations performed by your script up into 2 or more separate automations that use the same trigger

   • If it’s not possible to improve efficiency to the point that you are using less than 1000ms of CPU time, then pursue this by extracting functionality out of one automation script and into a new one
   • This will require writing a bit more code, and repetition of queries and such from one script to the next, but it may break up what you are trying to achieve enough that each separate automation script stays under the 1000ms CPU time limit
   • Be aware that Airtable also limits the number of Automations you can have active at a time (and thus, there is a hard cap to the CPU time you can consume in a single base) - I don’t know exactly what that limit is

If you need further help accomplishing either of these, post back with your script code and I’m sure I or somebody else on the forums can provide more specific guidance.

Thank you Jeremy this is very helpful! This is the script code - I created it based on a video I found in this thread on creating a script for vlookups / linked records.

I want to automatically link records in two different tables using the records’ Email address as the reference point. Very possible that it’s not the most efficient script but I don’t think with my knowledge I’ll be able to identify efficiencies. If you or anyone else has advice, it would be much appreciated.

When you open up the Script editor, after having captured a record in the trigger (a record that has either been created or that has entered a view), you can pull that same record into the script by adding it to the input variable on the left side:

Just select + Add input variable, give it the name by which you will retrieve it, and for “Value” use the blue + button to find the Record ID of the record that triggered Step 1.

Then, you can retrieve that record from the input variable in your script, and act only on that record. So your new script might look something like this:

Here’s a copy-pastable version of that:

let recordId = input.config().recordID

let trainingTable = base.getTable("Training | Started")
let recordQuery = await trainingTable.selectRecordsAsync()
let recordToUpdate = recordQuery.records.find(record => record.id == recordId)
let trainingEmail = recordToUpdate.getCellValue("Email")

let applicationsQuery = await base.getTable("Applications").selectRecordsAsync()
let applicationsToLink = applicationsQuery.records.map(applicationRecord => {
    if (applicationRecord.getCellValue("Email") === trainingEmail) {
        return { id: applicationRecord.id }
    }
})

await trainingTable.updateRecordAsync(recordId, {
    "Applications record": [applicationsToLink]
})