How can you tell if the action triggered the onEdit feature in the Google Apps scripts? The actions I have found to activate it include:
- edit a cell
- delete a cell or range
- cut or copy a cell or range
- Copy a sheet
I would like something similar to the changeType attribute of onChange that tells me what the user did.
I need to react to what the user is doing. If you are deleting a cell, it can not be columns 1 or 2, but it can be 1 or 2 if you are deleting a row. If they duplicate the sheet, they should be able to copy columns 1 and 2.
I can not figure out how to say the type of action the user did in any way.
I'm pretending looking at the row that the user edited and the oldValue attribute, but it's not completely accurate and my code seems very fragile.
The function of change of event does not have the attributes that I need like source, rank, old value and value.