113 reputation
5
bio website propertytaxservices.com
location Toronto, Canada
age 46
visits member for 1 year, 5 months
seen Jul 18 at 19:06

I am a tax lawyer by training, but I am more interested in learning how to code.


May
26
comment Prevent “invoked too many times per second” error in Google Apps Script
This is a great solution. Thanks so much for showing me how to do it.
May
26
awarded  Scholar
May
26
accepted Prevent “invoked too many times per second” error in Google Apps Script
May
4
comment Prevent “invoked too many times per second” error in Google Apps Script
Hi Jacob - I sent you an email so that you could see the doc I was talking about. Did you receive it?
May
2
comment Prevent “invoked too many times per second” error in Google Apps Script
Ok, penny just dropped. I understand what you mean now. Thanks for sticking with me.
May
2
comment Prevent “invoked too many times per second” error in Google Apps Script
Sorry, but still not following you. If I have 1000 cells that need to be updated, I don't know how to do that without using 1000 function calls, one in each cell, regarding of how the function itself has been coded.
May
2
comment Prevent “invoked too many times per second” error in Google Apps Script
Thanks for the suggestion to use a lookup, but I still don't understand how that will solve my original problem. Wouldn't I simply be replacing one function with another and still run into "too many times per second" error? If I have 20 tabs, with 50 function calls per tab, does that mean the function is called 1000 times, whether I view the tab or not?
May
1
awarded  Editor
May
1
revised Prevent “invoked too many times per second” error in Google Apps Script
Added code
May
1
awarded  Student
May
1
comment Prevent “invoked too many times per second” error in Google Apps Script
Thanks for the suggestion. Now I just need to figure out how to implement that suggestion. Do you have any ideas how I could run the function once, but then loop all of the rows in the tab with one function call?
May
1
revised Prevent “invoked too many times per second” error in Google Apps Script
edited tags
May
1
asked Prevent “invoked too many times per second” error in Google Apps Script
Feb
21
awarded  Autobiographer
Feb
21
awarded  Supporter