CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetstriggersonchange
Ramuk
Ramuk

Reputation: 217

Google Spreadsheet Script onChange event not firing

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?

Upvotes: 7

Views: 32775

Answers (3)

Md Nazmus Sakib
Md Nazmus Sakib

Reputation: 29

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();
    }

Upvotes: 5

Mario
Mario

Reputation: 241

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:

enter image description here

Upvotes: 11

Ramuk
Ramuk

Reputation: 217

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.

Upvotes: 3

Related Questions