triggers - TypeError: Cannot read property "source" from undefined. (line 339, file "Code") -
please can me fix following error.
typeerror: cannot read property "source" undefined. (line 339, file "code")
function myfunction(e) { var getsheet = e.source.getsheetname(); var getrange = e.range.getcolumn(); if(getsheet == "wesham excess" && getrange == 3 || getsheet == "wesham stock req"){ var stockemail = "excessstock@greenlifepharma.co.uk"; var stockreqemail = "wholesale@greenlifepharma.co.uk"; mailapp.sendemail( (getsheet == "wesham excess") ? stockemail : stockreqemail , "excess stock - branch has added stock ", "please see changes on main list of spreadsheet"); } }
thanks in advance!
Comments
Post a Comment