4 ms·
I know of it. The main issue is it has a 30 second execution script time limit for custom functions [1]. So if you want to build anything that could take longe
by samanator 6y ago
I know of it. The main issue is it has a 30 second execution script time limit for custom functions [1].
So if you want to build anything that could take longer than that to execute you need to make sure to write to the spreadsheet before 30 seconds elapse and have a recurring scheduled function that completes any unfinished jobs. Gets tedious and failure prone quickly IME.
[1] https://developers.google.com/apps-script/guides/services/quotas https://developers.google.com/apps-script/guides/services/qu...
- pbreit 6y agoOh, wow, that's terrible. I guess I haven't run into it. That would be a bit of a show-stopper for many of the projects I am contemplating.