使用FormApp [1]和SpreadsheetApp [2]方法,我制作了以下Apps脚本代码,该代码可以发送带有电子表格信息的多个表单响应(学生ID为A列,笔记为B列):
function myFunction() {
var existingForm = FormApp.openById('[FORM-ID]');
var questions = existingForm.getItems();
var IdQuestion = questions[0];
var AIQuestion = questions[1];
var NotesQuestion = questions[4];
var spreadsheet = SpreadsheetApp.openById("[SPREADSHEET-ID]");
var sheet = spreadsheet.getSheets()[0];
var data = sheet.getDataRange().getValues();
for (var i = 1; i<data.length ; i++) {
var response = existingForm.createResponse();
response.withItemResponse(IdQuestion.asTextItem().createResponse(data[i][0]));
response.withItemResponse(NotesQuestion.asTextItem().createResponse(data[i][1]));
response.withItemResponse(AIQuestion.asListItem().createResponse("assigned tutorial"));
response.submit();
}
}
您需要在代码中同时替换SpreasheetID和FormId。电子表格中的数据从第二行(标题的第一行)开始。
[1] https://developers.google.com/apps-script/reference/forms/form-app
[2] https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app
本文链接:https://www.f2er.com/3115170.html