sauntimo

function formSubmitReply(e) {

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

var  NewSubmission = {  
    "Timestamp" : e.values[0],
    "Favourite Colour" : e.values[1],
    "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 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

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

<table style="border:2px solid black;width:500">
<tbody>
<tr><th colspan="2" bgcolor="#c7ced4">Section One: Product Details</th></tr>
<tr bgcolor="#d0eaf9"><td>Size</td><td>10" - £25</td></tr>
<tr><td>Style</td><td>Victoria Sponge Cake</td></tr>
<tr bgcolor="#d0eaf9"><td>Filling</td><td>Strawberry Jam</td></tr>
<tr><td>Topping</td><td>Buttercream</td></tr>
<tr bgcolor="#d0eaf9"><td>Decoration</td><td>Marshmallows, Strawberries, "Happy Birthday!"</td></tr>
<tr><th colspan="2" bgcolor="#c7ced4">Section Two: Delivery Details</th></tr>
<tr bgcolor="#d0eaf9"><td>First name</td><td>Joe</td></tr>

sauntimo

function CakeOrder(e){

  
  
/* ----- CREATE NEWSUBMISSION OBJECT ----- */
  
  
  
var NewSubmission = {};
  

sauntimo

/*  ----- BUILD HTML RESPONSE TABLE ----- */
  
var HTMLtable = "<table style=\"border:2px solid black;width:500\" >";
var rowCount = 0;
  
for (var property in NewSubmission) {
  if(NewSubmission[property].length != 0){
    if(property.substring(0,7) === "Section"){
      HTMLtable += "<tr><th colspan=\"2\" bgcolor=\"#c7ced4\">"+ property +"</th></tr>";
    } else {

sauntimo

/* ----- CREATE NEWSUBMISSION OBJECT ----- */
  
var NewSubmission = {};
  
var Properties = ["Section One: Product Details","Size","Style","Filling","Topping","Decoration",
                  "Section Two: Delivery Details","First name","Family name","Email Address","Address","Delivery","Day","Month","Year"];
  
var i = 0;
var iSkip = 0;
  

sauntimo

// Create string version of date entered to be read by humans
NewSubmission["Delivery Date"] = NewSubmission["Day"] + "-" + NewSubmission["Month"] + "-" + NewSubmission["Year"];  
    
 
// create Javascript Date instance from date string
var OrderFor = new Date(NewSubmission["Month"] + " " + NewSubmission["Day"] + ", " + NewSubmission["Year"]); 

// These properties aren't needed as we have NewSubmission["Delivery Date"] which is DD-MM-YYYY
delete NewSubmission["Day"];
delete NewSubmission["Month"];

sauntimo

function logIncomingEmails() {
 
  var EmailLog = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Email Log")
  var rows = EmailLog.getDataRange();
  var numEmailRows = rows.getNumRows();
  
  var Unlogged = GmailApp.getUserLabelByName("Unlogged")
  var Logged = GmailApp.getUserLabelByName("Logged")
  var UnloggedThreads = Unlogged.getThreads(0,50);   // Returns an array of the first 50 unlogged threads. Hopefully there won't be more than 50 per minute!