Calling function when checking checkbox - Google Sheets

Question

I am trying to call a function when someone check a checkbox. I came up with this so far but it is not working. Checkboxes are in cells F2 and F3

function onEdit(e) {
  var range = e.range
  if(range.getCell() == "F2") {
    resetData()
  }
  else if(range.getCell() == "F3") {
    renameSheet()
  }
}

zummon · Accepted Answer · 2020-05-01 06:37:51Z

2

It has many ways to do this. The basic one is

function onEdit() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet()
  if (sheet.getRange("F2").isChecked()) {
    resetData()
  } else if (sheet.getRange("F3").isChecked()) {
    renameSheet()
  }
}

Addition with uncheck after the click

function onEdit() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet()
  var range = sheet.getActiveRange()
  if (range.isChecked()) {
    if (range.getA1Notation() == "F2") {
      resetData()
    } else if (range.getA1Notation() == "F3") {
      renameSheet()
    }
    range.uncheck()
  }
}

answered May 1, 2020 at 6:37

zummon

9964 gold badges11 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Cacadours Over a year ago

Thanks a lot for your reply. That works well. I am trying to make it work with an installable trigger, I changed the onEdit() to onInstallableEdit() and tried to create a trigger that called onInstallableEdit() and it doesn't do anything. Do you have an idea why ?

Cacadours Over a year ago

I made it work, I made a mistake on the function call. Thanks a lot for your help

zummon Over a year ago

I'm happy to help. About onInstallableEdit() I think it won't trigger things, it's just a regular function. This the limit we can do developers.google.com/apps-script/guides/triggers

Collectives™ on Stack Overflow

Calling function when checking checkbox - Google Sheets

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related