运行谷歌应用程序脚本将单个谷歌表单链接导入谷歌(响应)表时，不断出现语法错误

Question

运行Google Apps脚本将单个Google表单链接导入Google(响应(工作表时，不断出现语法错误。有人能确定问题吗？

请参阅脚本：

function assignEditUrls() {
var form = FormApp.openById('1FyNUeFk_bEqraE9TNLbFMQimKtp93mInqPP6IhJDJ_s');
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Form Responses 1');
var data = sheet.getDataRange().getValues();
var urlCol = 87;
var responses = form.getResponses();
var timestamps = [], urls = [], resultUrls = [];
for (var i = 0; i < responses.length; i++) {
timestamps.push(responses[i].getTimestamp().setMilliseconds(0));
urls.push(responses[i].getEditResponseUrl());
for (var j = 1; j < data.length; j++) {

resultUrls.push([data[j][0]?urls[timestamps.indexOf(data[j][0].setMilliseconds(0))]:""]);

sheet.getRange(2, urlCol, resultUrls.length).setValues(resultUrls);
}

Answer 1

我认为这是：

for (var j = 1; j < data.length; j++) {
resultUrls.push([data[j][0]?urls[timestamps.indexOf(data[j][0].setMilliseconds(0))]:""]); 
sheet.getRange(2, urlCol, resultUrls.length).setValues(resultUrls);
}

应该是

for (var j = 1; j < data.length; j++) {
resultUrls.push([data[j][0]?urls[timestamps.indexOf(data[j][0].setMilliseconds(0))]:""]);
}
}
sheet.getRange(2, urlCol, resultUrls.length).setValues(resultUrls);
}

您应该只需要执行一次setValues((