14a Problem log & email

14a-Problem log & email

function sendProblem() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var fr = ss.getSheetByName("Form Responses 1");
  var lastRowValues = fr.getRange(fr.getLastRow(), 1, 1, fr.getLastColumn()).getValues();
  var problem = lastRowValues[0][1]; 
  var room = lastRowValues[0][2];
  
//Create email
  var emailSubject = "Problem";
  var emailTo = ["email1@gmail.com", "email2@gmail.com"]; 
  var emailBody = "Problem: " + problem + "<br /> \
  Room: " + room;

//Send email
  MailApp.sendEmail(emailTo,emailSubject,'body',{
  htmlBody: emailBody});   
}