我有這個 google 腳本代碼,它根據條件發送電子郵件。代碼從不同的列中獲取數據,電子郵件的輸出如下所示:
現有代碼:
function sendEmails()
{
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 1; // First row of data to process
var numRows = 6; // Number of rows to process
// Fetch the range of cells A1:P300
var dataRange = sheet.getRange(startRow, 1, numRows, 13);
// Fetch values for each row in the Range.
var data = dataRange.getValues();
var dayofemail = data[0][12];
data.reduce((m, [qua_num,manufacturer,model,serial,descrip,,,,daysPastCal,emailAddress]) => {
if (daysPastCal > -14) m.set(emailAddress, m.has(emailAddress) ? [...m.get(emailAddress), qua_num,manufacturer,model,serial,descrip] : [qua_num,manufacturer,model,serial,descrip]);
return m;
}, new Map())
.forEach((qua_num, emailAddress) => {
var message = qua_num.join('\n') + '\nThe above equipment are approaching due date or out of cal.\nPlease check with QA for replacement or sending the equipment out for re-calibration.';
var subject = 'AUTOMATED ALERT: CHECK EQUIPMENT CALIBRATION ';
MailApp.sendEmail(emailAddress, subject + dayofemail, message);
});
}
輸出
QUA-014
COHERENT
J-10GE-LE
0303C15R
SENSOR
QUA-029
FLUKE
115
248301132
DIGITAL MULTIMETER
The above equipment are approaching due date or out of cal.
Please check with QA for replacement or sending the equipment out for
re-calibration
我想看到這樣的電子郵件:
QUA-014 COHERENT J-10GE-LE 0303C15R SENSOR
QUA-029 FLUKE 115 248301132 DIGITAL MULTIMETER
The above equipment are approaching due date or out of cal.
Please check with QA for replacement or sending the equipment out for
re-calibration
我如何在谷歌腳本中實現這一點?
不完全可維護代碼的好例子......好吧,我會嘗試\n
在這一行中添加兩個:
if (daysPastCal > -14) m.set(emailAddress, m.has(emailAddress) ?
[...m.get(emailAddress), qua_num,manufacturer,model,serial,descrip] :
[qua_num,manufacturer,model,serial,descrip]);
這邊走:
if (daysPastCal > -14) m.set(emailAddress, m.has(emailAddress) ?
[...m.get(emailAddress), qua_num,manufacturer,model,serial,descrip,'\n'] :
[qua_num,manufacturer,model,serial,descrip,'\n']);
並更改\n
到\t
這裡:
var message = qua_num.join('\n') + ...
這邊走:
var message = qua_num.join('\t') + ...
但是我無法檢查它,因為您沒有提供可重現的代碼。
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句