从表单中自动填充Google文档查找最后一行

function autoFillForm() {
  // 获取当前文档的活动表单
  var form = FormApp.getActiveForm();
  
  // 获取表单的所有问题
  var questions = form.getItems();
  
  // 创建一个空数组，用于存储每个问题的答案
  var answers = [];
  
  // 遍历每个问题，并从表单中获取答案
  for (var i = 0; i < questions.length; i++) {
    var question = questions[i];
    var answer = getAnswer(question);
    answers.push(answer);
  }
  
  // 将答案填充到最后一行
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var lastRow = sheet.getLastRow();
  var range = sheet.getRange(lastRow + 1, 1, 1, answers.length);
  range.setValues([answers]);
}

function getAnswer(question) {
  // 根据问题的类型获取答案
  var type = question.getType();
  
  switch (type) {
    case FormApp.ItemType.TEXT:
      return "文本答案";
    case FormApp.ItemType.MULTIPLE_CHOICE:
      return "选择答案";
    // 添加其他问题类型的处理逻辑
    // ...
    default:
      return "";
  }
}