Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var ss = SpreadsheetApp.getActive();
- var sheet = SpreadsheetApp.getActiveSheet();
- function onEdit(e) {
- var row = e.range.getRow();
- var col = e.range.getColumn();
- var status = e.range.getValue();
- if (col == 8) {
- var email = "email1d@email.com";
- var title = sheet.getRange(row,1).getValue();
- var days = sheet.getRange(row,7).getValue();
- var dp = sheet.getRange(row,3).getValue();
- var reviewer = sheet.getRange(row,4).getValue();
- var reviewdate = sheet.getRange(row,6).getValue();
- var Temp Value4 = sheet.getRange(row,10).getValue();
- var usercomment = sheet.getRange(row,11).getValue();
- sendEmail(email, title, status, days, dp, reviewer, reviewdate, Temp Value4, usercomment);
- }
- }
- function sendEmail(email, title, status, days, dp, reviewer, reviewdate, Temp Value4, usercomment) {
- var subject = "Temp Value2 " + title + ' ' + status + '';
- var html = '<p> Updated for following Temp Value2: </p><br />' +
- '<b>Temp Value:</b> ' + dp + '<br />' +
- '<b>Temp Value2:</b> ' + title + '<br />' +
- '<b>Status:</b> ' + status + '<br />' +
- '<b>Temp value3:</b> <font color="red">' + days + '</font><br />' +
- '<b>Last review date:</b><font color="red"> ' + reviewdate + '</font><br />' +
- '<b>Temp Value4:</b><font color="red"> ' + Temp Value4 + '</font><br />' +
- '<b>User:</b> ' + reviewer + '<br />' +
- '<b>Temp Value5:</b> ' + usercomment + '<br />' +
- '<p><b><font size="2" color="blue">automated email</font></b></p> ';
- MailApp.sendEmail({
- to: email,
- subject: subject,
- htmlBody: html,
- noReply: true });
- }
Add Comment
Please, Sign In to add comment