'Having Google App Script run a condition from formula rather than a hardcode
I'm have the following script below for an active googlesheet as a means to send an email notification when a condition is met. Currently, the script functions as it should with the only caveat being that it only does so when the condition is hardcoded rather than reading directly from a formula.
Would truly appreciate any help in figuring this out.
function sendEmails(e){
const rData = e.source.getActiveSheet().getRange(e.range.rowStart, 1, 1, 12).getValues();
let repName = rdata[0][3];
let repStatus = rData[0][4];
let repMarket = rData[0][0];
let repSeg = rData[0][1];
if(e.range.columnStart != 12 || e.values = "True") return;{
GmailApp.sendEmail(email, "test email", "test message")
}
}
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
