“已超出您的触发器配额” [英] "Your quota of triggers has been exceeded"

问题描述

任务：
对于我们的每个客户，我们都需要构建八个电子表格，每个电子表格至少包含两个触发器：1）打开时； 2）基于时间从中刷新特定数据更大的电子表格。 （这是IMPORTRANGE功能失败的一种解决方法。）

Task: For each of our clients, we need to build eight spreadsheets with a minimum of two triggers each: 1) on Open and 2) Time based to refresh specific data from a larger spreadsheet. (This is a workaround for failing IMPORTRANGE functions.)

我们目前有100个客户端，不久将扩展到200个。因此，我们目前的需求约为800个电子表格和1,600个触发器。预计很快就会分别达到1600和3200。

We currently have 100 clients, and are expanding to 200 shortly. Therefore, our current need is approximately 800 spreadsheets, and 1,600 triggers; projected to be 1,600 and 3,200 respectively very soon.

问题
创建前300个电子表格（大约600个触发器）后，收到以下错误：

Problem After creating the first 300 spreadsheets (approximately 600 triggers) we have received the following error:

已超过触发器配额。要创建更多触发器，必须删除一些现有触发器。

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

所需的解决方案：
在每个客户的私有Google网站上收集八个电子表格。理想情况下，我们可以从站点调用每个电子表格脚本，并消除基于时间的触发器。尝试创建一个按钮来执行脚本，但是在站点上，它不是交互式的。

Desired Solution: We are collecting the eight 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.

问题：
在Windows上运行7，Chrome中的错误也尝试了Firefox，并且出现了相同的错误。

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

1）a有谁知道触发器的限制，它是否发布在某处？

1)a Does anyone know of the limits on triggers, is it published somewhere?

1）b有没有办法提高这些限制？

1)b Is there a way to increase these limits?

2）关于其他解决方法或解决方案有什么想法吗？

2) Any ideas on another work around or solution?

推荐答案

Eric已经回答了您的问题（1）。 （不，不）

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

问题（2），一种可能的解决方法是反转脚本的场景，而不是每个脚本都在较大的电子表格，那么您母版上的单个脚本就可以将数据分发到所有其他电子表格中。您可以对每个电子表格进行某种注册，或者将它们放置在相同的文件夹中，或者使用其他适合您的方式。

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.

通过更改此方法一个，您肯定会遇到另一个限制，那就是脚本的总运行时间：6分钟。但是，您可以通过将任务分成较小的块来轻松解决此问题，这些块可以在每分钟的触发器上工作并恢复。

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.

这篇关于“已超出您的触发器配额”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！