Guest User

Untitled

a guest
Jun 19th, 2018
197
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.47 KB | None | 0 0
  1. var ss = SpreadsheetApp.getActive();
  2. var sheet = SpreadsheetApp.getActiveSheet();
  3.  
  4. function onEdit(e) {
  5. var row = e.range.getRow();
  6. var col = e.range.getColumn();
  7. var status = e.range.getValue();
  8. if (col == 8) {
  9. var email = "email1d@email.com";
  10. var title = sheet.getRange(row,1).getValue();
  11. var days = sheet.getRange(row,7).getValue();
  12. var dp = sheet.getRange(row,3).getValue();
  13. var reviewer = sheet.getRange(row,4).getValue();
  14. var reviewdate = sheet.getRange(row,6).getValue();
  15. var Temp Value4 = sheet.getRange(row,10).getValue();
  16. var usercomment = sheet.getRange(row,11).getValue();
  17. sendEmail(email, title, status, days, dp, reviewer, reviewdate, Temp Value4, usercomment);
  18. }
  19. }
  20.  
  21. function sendEmail(email, title, status, days, dp, reviewer, reviewdate, Temp Value4, usercomment) {
  22. var subject = "Temp Value2 " + title + ' ' + status + '';
  23. var html = '<p> Updated for following Temp Value2: </p><br />' +
  24. '<b>Temp Value:</b> ' + dp + '<br />' +
  25. '<b>Temp Value2:</b> ' + title + '<br />' +
  26. '<b>Status:</b> ' + status + '<br />' +
  27. '<b>Temp value3:</b> <font color="red">' + days + '</font><br />' +
  28. '<b>Last review date:</b><font color="red"> ' + reviewdate + '</font><br />' +
  29. '<b>Temp Value4:</b><font color="red"> ' + Temp Value4 + '</font><br />' +
  30. '<b>User:</b> ' + reviewer + '<br />' +
  31. '<b>Temp Value5:</b> ' + usercomment + '<br />' +
  32. '<p><b><font size="2" color="blue">automated email</font></b></p> ';
  33.  
  34. MailApp.sendEmail({
  35. to: email,
  36. subject: subject,
  37. htmlBody: html,
  38. noReply: true });
  39. }
Add Comment
Please, Sign In to add comment