在google script中解析和显示表单

function parseAndDisplayForm() {
  var form = FormApp.getActiveForm();
  var formResponses = form.getResponses();
  
  // 解析表单数据
  for (var i = 0; i < formResponses.length; i++) {
    var response = formResponses[i];
    var itemResponses = response.getItemResponses();
    
    // 处理每个表单字段的响应
    for (var j = 0; j < itemResponses.length; j++) {
      var itemResponse = itemResponses[j];
      var question = itemResponse.getItem().getTitle();
      var answer = itemResponse.getResponse();
      
      // 在控制台打印表单数据
      Logger.log(question + ': ' + answer);
    }
  }
  
  // 创建自定义界面来显示表单数据
  var htmlOutput = HtmlService.createHtmlOutput('<h1>表单数据</h1>');
  var body = htmlOutput.getBody();
  
  // 在自定义界面中显示表单数据
  for (var i = 0; i < formResponses.length; i++) {
    var response = formResponses[i];
    var itemResponses = response.getItemResponses();
    
    // 显示每个表单字段的响应
    for (var j = 0; j < itemResponses.length; j++) {
      var itemResponse = itemResponses[j];
      var question = itemResponse.getItem().getTitle();
      var answer = itemResponse.getResponse();
      
      // 在自定义界面中添加表单数据
      body.append('<p>' + question + ': ' + answer + '</p>');
    }
  }
  
  // 显示自定义界面
  SpreadsheetApp.getUi().showModalDialog(htmlOutput, '表单数据');
}