Google Spreadsheet Script onChange event not firing

Question

I am trying to fire an onChange event and it is not working.

I have the following simple code:

function onChange(){
  Logger.log("onChange event fired");
}

function onEdit(){
  Logger.log("onEdit event fired");
}

https://developers.google.com/apps-script/understanding_events

According the this document, the onChange event should be fired when a row is inserted. It does not get fired. The onEdit function gets fired when you manipulate a cell, but I need an event to be fired when the user inserts a row as well.

Any thoughts?

Answer 1

Try to use signatures with one parameter:

function onChange(e){
  Logger.log("onChange event fired");
}

function onEdit(e){
  Logger.log("onEdit event fired");
}

And then register those functions in ScriptEditor:

Answer 2

onChange is an install-able trigger. Use the following function to install the trigger.

    function createSpreadsheetChangeTrigger() {
    var ss = SpreadsheetApp.getActive();
    ScriptApp.newTrigger('onChange')
      .forSpreadsheet(ss)
      .onChange()
      .create();
    }  

Answer 3

In the script editor I clicked the Resources menu and selected 'All your triggers' from there I was able to register my onChange function to actually be triggered on change of the spreadsheet.

Edit: People were telling me to do this with code, I couldn't get that to work. Found the gui method buried in the docs.