javascript - 创建触发器时如何循环访问 Google Sheet 中的值？

Question

我有以下格式的 Google Apps 脚本代码:

var key = "ID of the Sheet";

var key1 = "ID of the Sheet";

function createTriggers() {

  ScriptApp.newTrigger('filter')
      .forSpreadsheet(key)
      .onEdit()
      .create();
}

function createTriggers() {

  ScriptApp.newTrigger('filter')
      .forSpreadsheet(key1)
      .onEdit()
      .create();
}

如何循环遍历所有键(key、key1、key2...)并通过单个函数创建触发器？

Answer 1

类似这样的事情:

function createTriggers() {
    var keys = [
        'key1',
        'key2'
    ]
    for (var i = 0; i < keys.length; i++) {
        ScriptApp.newTrigger('filter')
            .forSpreadsheet(keys[i])
            .onEdit()
            .create();
    }
}

Information about for loops