Instructions for setting orders via Google Form

Instructions for setting up orders appear on Google spreadsheets and notify via email immediately. This trick is very simple, please watch the video.

function guiBieuMau(e)


{


  // Replace with your email address


  var email = "diachimail@gmail.com";


  // Subject of the email sent


  var subject = "Orders at ABCD shop";


  // If you don't know how, 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);


}