Weird Issue Maybe 2019 Problem?

[MCMan6482]

Heyo, I'm from team 2551 and was loving using this app,
However as our scouting sheet has expanded there's been an issue we can't seem to rectify on our end. Over time random cells with data are replaced with #ERROR and when hovered over says "Service invoked too many times in a short time: exec qps. Try Utilities.sleep(1000) between calls. (line 0)."

If you'd be able to pop in and see whats up it'd be a HUGE help. Feel free to contact me with any questions [email protected]

Thanks!

[Eiim]

It's not a 2019 problem, it just wasn't designed for scouting sheets that epic! :P

It seem like you're calling the TBA API too many times at once. The short-term solution would be to put in half the calls at one point, wait for them to load, and then add the other half. If you have lots up updating cells, you might be able to stagger them by only updating the second half once all of the first half has been updated. I'm not sure exactly what this looks like, but it seems potentially doable, maybe with some kind of control cell which changes once the first half has finished.

The long-term solution is to refactor significant sections of the code so that it handles caching better, which would solve some other issues as well. However, I'm not well versed in Google Sheet's caching mechanisms and I'm a bit busy preparing (surprise surprise!) scouting right now, so that's unlikely to happen before the end of 2019 unless someone more knowledgeable in Google Sheets function caching than I gets involved.

If you still are having issues, feel free to send me the sheet and I can have a look!