+3I am trying to run a script through a button triggered automation, but I am running into an error for exceeding the time limit of 30 seconds for execution. Is there a way that I can get around this so I can run the script?
I have heard that people have been running the scripts in batches, however, I am not too sure how people are doing this as I cannot find an tutorials on how to work it into the automation.
Any ideas?
+35I don’t know how to split your script into multiple scripts, but do you actually need to run a script?
Instead, you can simply outsource your automations to Make’s advanced automations & integrations for Airtable
Make has an execution time limit of 40 minutes per automation.
Even better, you don’t need to know Javascript to use Make, because it is a low-code/no-code platform.
However, if you DO want to write JavaScript code, you can do that with Make’s Code Module.
If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.
I also give live demonstrations of how to use Make in many of my Airtable podcast appearances. For example, in this video, I show how to work with Airtable arrays in Make.
Hope this helps!
If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+29You cannot get around the limit of 30 seconds for scripting automations.
What does the script do, and what is causing it to take so long?
If you are updating multiple records one-at-a-time, this example script by Airtable shows one method of updating records in batches of 50.
+3You cannot get around the limit of 30 seconds for scripting automations.
What does the script do, and what is causing it to take so long?
If you are updating multiple records one-at-a-time, this example script by Airtable shows one method of updating records in batches of 50.
The script goes through each row to calculate a running total of what the consultant is to be paid out on each invoice, so the amount in the payout column is the threshold (as a negative) + all their splits. Acts as a running total for each invoice.
One way to extend the time needed for a script is to break your script up into section and then string them together in an automation. Each script has the 30 second time limit (i think this went up to 120) but altogether you have a 5 minute limit. That's from memory. I wasn’t able to find this by searching on the web . . but I remember reading that somewhere.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.