Bot executes Script Trigger twice (due to timeout?)

For a quick introduction rather than posting a bunch of code, I set up a bot to run on 'adds only' for one table that runs a Apps Script function creating a bunch of rows in other tables. The particular function that is triggered times out at just under 360 seconds. Then it apparently restarts from the beginning.

The bot is supposed to trigger two additional scripts after that, which never occur due to the function in the first triggered script repeating. I have cancelled the execution of the second time the function executes in order to not create too many records.

First off, is this the designed behavior, and second what would be a potential workaround? I suspect anyone could attempt to duplicate this by just adding a JS timeOut() function in the script to see if they get the same result. I have a screenshot below showing the two executions spaced about 5 minutes apart. Do note that the second execution started automatically, I did not introduce a loop that starts the function over.

Markus_Malessa_0-1685465395472.png

 

0 5 8,594
5 REPLIES 5
Top Labels in this Space