Google Apps脚本触发器：您的触发器配额已超出

现在回到问题（2），可能的解决方法是反转脚本的场景，而不是每个脚本都将其数据放在更大的电子表格，主人的一个脚本可以将数据分发到所有其他电子表格中。您可以对每个电子表格进行一些注册，也可以将它们放在同一个文件夹中，或者其他任何适合您的方式。通过改变这种方法一，你一定会遇到另一个限制，这是脚本总运行时间：6分钟。但是，您可以轻松解决此问题，方法是将任务分解为可以在每分钟触发器上工作并恢复的小块。

Task: For each of our clients, we need to build 8 spreadsheets with min 2 triggers each. 1) on Open and 2) Time based to refresh specific data from a larger spreadsheet. (This is a work around for failing importrange functions)

We currently have 100 clients, and are expanding to 200 shortly.

Therefore, our current need is apprx 800 spreadsheets, and 1,600 triggers; projected to be 1,600 and 3,200 respectively very soon.

Problem After creating the first 300 spreadsheets apprx 600 triggers, we have received the following error:

"Your Quota of Triggers has been exceeded. To Create more, you must delete some existing triggers."

Desired Solution: We are collecting the 8 spreadsheets on a private google site for each client. Ideally we could invoke each spreadsheet script from the site, and eliminate time-based triggers. Tried creating a button to execute the script, but on the site, it is not interactive.

Questions: Operating on Windows 7, error is in Chrome also tried firefox, and got same error.

1) Does anyone know of the limits on triggers, is it published somewhere?Is there a way to increase these limits?

2) Any ideas on another work around or solution?

Any help/advice is greatly appreciated. Many thanks,

Eric already answered your question (1). (No, and no)

Now to question (2), a possible workaround is to invert the scenario of your scripts, instead of each script fetch its data on the "larger spreadsheet", a single script on your master could distribute the data on all other spreadsheets. You could have some kind of "registration" of each spreadsheet, maybe place them in the same folder, or any other way that suit you.

By changing the approach to this one, you'll surely run into another limitation, which is the script total run time: 6 minutes. But this problem you can easily work around by splitting the task into minor chunks that you can work and resume on a every minute trigger.