我是脚本新手,添加了这个有效的脚本:
function sendEmailAlert() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var cellValue = ss.getActiveSheet().getActiveRange().getA1Notation();
var getRow = ss.getActiveSheet().getActiveRange().getRow();
var sheetname = ss.getActiveSheet().getName();
var user = Session.getActiveUser().getEmail();
var Toemail = '....email address....';
var subject = 'New Entry -' + ss.getName();
var body = 'Your file has a new entry in - ' + sheetname + ' Updated by - ' + user + ' check file- ' + ss.getUrl();
if(Number(ss.getActiveCell().getValue()!=-1.23456789) && getRow ==3) {
MailApp.sendEmail(Toemail,subject, body);
}
};
但是,由于我想找出更改了哪个特定单元格以及新值,因此更新后的脚本无法保存,因此我无法运行它。我猜错误是在 var body 中,有人可以帮忙吗?
function sendEmailAlert() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var cellValue = ss.getActiveSheet().getActiveRange().getA1Notation();
var getRow = ss.getActiveSheet().getActiveRange().getRow();
var sheetname = ss.getActiveSheet().getName();
var user = Session.getActiveUser().getEmail();
var Toemail = '...email address';
var subject = 'New Entry -' + ss.getName();
var body = 'Your file has a new entry in - ' + sheetname + ' Updated by - ' + user + ‘New Value in –‘ + cellValue + ‘= ‘ +ss.getActiveCell().getValue() +
' check file- ' + ss.getUrl();
if(Number(ss.getActiveCell().getValue()!=-1.23456789) && getRow ==3) {
MailApp.sendEmail(Toemail,subject, body);
}
};
你说得对,有问题var body
代码行: 有‘
(大引号)而不是'
(直引号)。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)