Google App Scriptメモ

00_README.md

Google App Scriptメモ

10_getAnserList.js

function responseURL() {
 // Open a form by ID and log the responses to each question.
 var form = FormApp.openById('xxxxxxxxxxxxxxxxxx'); //this is the ID in the url of your live form
 var formResponses = form.getResponses();
 for (var i = 0; i < formResponses.length; i++) {
   var formResponse = formResponses[i];
   Logger.log(formResponse.getItemResponses()[0].getResponse());
   Logger.log(formResponse.getItemResponses()[1].getResponse());
   Logger.log(formResponse.getItemResponses()[2].getResponse());
   Logger.log(formResponse.getEditResponseUrl());
   Logger.log('------------------------------------');
 }
}

11_GoogleFormEditer.js

// get method
function doGet(e) {

  var list = responseURL(),
      htmlBuild ='',
      htmlBefore = '<table><tr><td>',
      htmlAfter =  '</td></tr></table>';
  list.forEach(function(v){
    htmlBuild += v.time + '</td><td>' +
                 v.name + '</td><td>' +
                 v.timeFxOS + '</td><td>' +
                 v.timeRasp + '</td><td><a href="' +
                 v.url +'" target=”_blank”>編集</a></tr><tr>';
  });
  return HtmlService.createHtmlOutput(htmlBefore + htmlBuild + htmlAfter);
}
function responseURL() {
  var ret = []
 var form = FormApp.openById('xxxxxxxxxxxxxxxxx');
 var formResponses = form.getResponses();
 for (var i = 0; i < formResponses.length; i++) {
   var formResponse = formResponses[i];
   ret.push({
     time: formResponse.getTimestamp(),
     name:formResponse.getItemResponses()[0].getResponse(),
     timeFxOS:formResponse.getItemResponses()[1].getResponse(),
     timeRasp:formResponse.getItemResponses()[2].getResponse(),
     url: formResponse.getEditResponseUrl()
   });
 }
 return ret;
}