script : function sendMailEdit(e){ if (e.range.columnStart != 5 || e.value != "Approved") return; const rData = e.source.getActiveSheet().getRange(e.range.rowStart,1,1,4).getValues(); let n = rData[0][2]; let d = new Date(rData[0][0]).toLocaleDateString("en-US"); let items = rData[0][3]; let loc = rData[0][1]; let now = new Date().toLocaleString("en-US");
let msg = "Order number " + n + " (" + d + ") containing " + items + " items from " + loc + " Approved at " + now; Logger.log(msg); GmailApp.sendEmail("receipient_email_address", "Approved Order", msg) }
شكراً جزيلا
موفق استاد رشيد انا من متابعين محتواك الجيد على صفحتك على الفيسبوك
salam khoya fin nl9a had skript
script :
function sendMailEdit(e){
if (e.range.columnStart != 5 || e.value != "Approved") return;
const rData = e.source.getActiveSheet().getRange(e.range.rowStart,1,1,4).getValues();
let n = rData[0][2];
let d = new Date(rData[0][0]).toLocaleDateString("en-US");
let items = rData[0][3];
let loc = rData[0][1];
let now = new Date().toLocaleString("en-US");
let msg = "Order number " + n + " (" + d + ") containing " + items + " items from " + loc + " Approved at " + now;
Logger.log(msg);
GmailApp.sendEmail("receipient_email_address", "Approved Order", msg)
}