Google Form Results - in Form View, the code for adding to your google form for triggering the email sent & embed the link that contents your result. Email me at mikekwyung@gmail.com, if you need assistance setting up your form:


function formSubmitReply() {

  //change the 3 variables below that's related to your survey form  
  var prefilledURLPathHere ="https://docs.google.com/forms/d/1Xvn5PLbRfYavVspsdWyGz5A_OOQh_Q-Lz-6LO-31rzQ/";// change to your form's URL here
  var MyBossEmail = "mikekwyung@gmail.com";// fill in the email who is in charge of all the survey
  var myfieldname = new Array("entry.425914641","entry.1684434100","entry.2093234876");
  var myemailsubject ="My Survey Form Result in Form View";

  var param1 ="viewform?";
  var theformattedURL = "";
  
  
  var form = FormApp.getActiveForm();
  var formResponses = form.getResponses();
   var formResponse = formResponses[formResponses.length-1];
   var itemResponses = formResponse.getItemResponses();
   for (var j = 0; j < itemResponses.length; j++) {
     var itemResponse = itemResponses[j];
     var theitems = itemResponse.getResponse();
     
     //test if the response is an array
     if (theitems instanceof Array) 
     {
        for (var k = 0; k < theitems.length; k++) 
       {
         theformattedURL = theformattedURL + "&" + myfieldname[j] +  "=" +  escape(theitems[k]);
       }
       
      } else 
       {
         theformattedURL = theformattedURL + "&" + myfieldname[j] +  "=" +  escape(itemResponse.getResponse());
       }
     

      // this is only for debuggin
//     Logger.log('Response #%s to the question "%s" was "%s"',         (j + 1).toString(),         itemResponse.getItem().getTitle(),         itemResponse.getResponse());
     
   }
      var fullURL = prefilledURLPathHere + param1 + theformattedURL;
  
  MailApp.sendEmail(MyBossEmail,myemailsubject,fullURL);
}
Shared publiclyView activity