Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Trigger function by checking checkbox

enter image description here

I have a sheet with checkboxes in the first column. I would like to be able to trigger a function by checking a box. Right now all the checkboxes are set to false/unchecked. Is there anyway to trigger an event by checking a box?

like image 405
user1592380 Avatar asked Feb 28 '19 22:02

user1592380


1 Answers

The following is not much of an answer, but does log ONEDIT when clicking or unclicking a checkbox. Maybe it can be used as a start for something more complicated.

function onEdit(e){
  if (e.range.columnStart == 1 && e.range.columnEnd == 1 && e.range.rowStart <= 2000) {
    Logger.log('ONEDIT');

  }
}
like image 86
user1592380 Avatar answered Oct 07 '22 13:10

user1592380