how to assign onEdit to specigfic tab
function onEdit(e) {
var activeSheet = e.source.getActiveSheet();
var range = e.range;
if (activeSheet.getName() !== "Inventory" || e.value !== "notify") return;
range.setBackgroundColor('red');
var productname = range.offset(0, -3).getValue();
var productinventory = range.offset(0, -2).getValue();
var message = "Product variant " + productname + " has dropped to " + productinventory;
var subject = "Low Stock Notification";
var emailAddress = "[email protected]";
MailApp.sendEmail(emailAddress, subject, message);
range.offset(0, 1).setValue("notified");
}
Also in JavaScript:
- add 'no_errors_schema' to the '@ngmodule.schemas'
- javascript is variable a string
- return symmetric difference of the array javascript
- moment hour minute
- reload page javascript
- vs code enable "html" in "javascript"
- javascript return promise
- readonly attribute in html by javascript
- sequelize validation empty string
- Errors messages produced from JavaScript data validation.\
- jquery abort ajax
- relative width and height image react native
- open bootstrap modal using javascript
- button click event listener angular
- objeto con método javascript
- how to add img in next.js
- jednorozeclinda
- javascript convert to and from binary
- jquery if checkbox is checked
- button is not calling js function
- return only specific attributes when making query mongoose
- react native expo search bar
- set a value in session using javascript
- print all the nested json key value pair c#