I am using onEdit trigger in Google Sheet to send an email notification based on cell changes with certain conditions. That works fine, but the trigger also fires when a row is deleted and I get an error that the cells are undefined because of course the row was deleted. Is there a way to catch that event within onEdit? I know that I could use onChange as well, but would the onEdit event fire anyways?
Thanks for any tips.
I am not sure how to check for undefined values in the onEdit event within the e object.
Darek Madejski is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.