Need to reference a cell in an email subject.

Need to reference the cell left to the active cell i.e if cell in column B is changed, reference cell in same row in column A.

All of the code works apart from

var productname = range.getvalue("A"+range.getRow);

Would be very grateful if someone can point out as to where I am going wrong! Sure this will be very easy for someone that knows what they are doing.

function onEdit(e) {
    
      var range = e.range;
      
      if(range.getValue() < 100) {
        var productname = range.getvalue("A"+range.getRow);
        var message = "Product variant" + productname + "has dropped to " + range.getValue();
        var subject = "Stock Notification";
        var emailAddress = "[email protected]";
        MailApp.sendEmail(emailAddress, subject, message);
       
      }
    }

Need to reference a cell in an email subject.

Need to reference the cell left to the active cell i.e if cell in column B is changed, reference cell in same row in column A.

All of the code works apart from

var productname = range.getvalue("A"+range.getRow);

Would be very grateful if someone can point out as to where I am going wrong! Sure this will be very easy for someone that knows what they are doing.

function onEdit(e) {
    
      var range = e.range;
      
      if(range.getValue() < 100) {
        var productname = range.getvalue("A"+range.getRow);
        var message = "Product variant" + productname + "has dropped to " + range.getValue();
        var subject = "Stock Notification";
        var emailAddress = "[email protected]";
        MailApp.sendEmail(emailAddress, subject, message);
       
      }
    }

• javascript
• reference
• google-sheets
• cell

1 Answer 1

Try

var productname = range.offset(0,-1).getValue();

However, you may have to 'limit' the trigger to a certain sheet and even a certain column (col B ?)