Instructions for setting up orders via Google Form

Order setup instructions are displayed on a google spreadsheet and email notifications are sent immediately. This trick is very simple, please watch the video.

function guiBieuMau(e)


{


  // Replace with your email address


  var email = "diachimail@gmail.com";


  // Title of the email sent to


  var subject = "Order at shop ABCD";


  // If you're not familiar, don't touch the code below


  var s = SpreadsheetApp.getActiveSheet();


  var columns = s.getRange(1,1,1,s.getLastColumn()).getValues()[0];


  var message = "";


  for ( var keys in columns ) {


    var key = columns[keys];


    if ( e.namedValues[key] && (e.namedValues[key] != "") ) {




      message += key + ' :: '+ e.namedValues[key] + "\n\n";


    }


  }


  MailApp.sendEmail(email, subject, message);


}