sauntimo

function OnSubmit(e){
  
  var NewSubmission = {};
  
  var Properties = ["Timestamp","Favourite Colour","Explanation"];
  
  var i = 0;
    for(i = 0; i < Properties.length; i++){
    NewSubmission[Properties[i]] = e.values[i];
  }

sauntimo

function OnSubmit(e){

 MailApp.sendEmail("[email protected]", "Your form was submitted!", 
                   
                   "Hey you!" + 
                   "\n\n Someone submitted your form. Here's what they had to say:" +
                   "\n\n Favourite Colour: " + e.values[1] +
                   "\n Explanation: " + e.values[2])
  
}

sauntimo

/**
 * Retrieves all the rows in the active spreadsheet that contain data and logs the
 * values for each row.
 * For more information on using the Spreadsheet API, see
 * https://developers.google.com/apps-script/service_spreadsheet
 */
function readRows() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();

sauntimo

function formSubmitReply(e) {

/*  ----- CREATE NEW OBJECT FROM SUBMISSION ----- */     

var  NewSubmission = {  
    "Timestamp" : e.values[0],
    "Favourite Colour" : e.values[1],
    "Explanation" : e.values[2],
  }