up vote 7 down vote favorite
1

I know there's no checkbox functionality in a Google Docs spreadsheet but I was wondering if there's a way to get equivalent functionality somehow. What I'm looking for is a one click enable/disable or toggle in some form.

The closest I've come is manually editing a cell to enter a 0 or 1 but I'm hoping there's a nicer pattern.

share|improve this question

1 Answer

up vote 2 down vote accepted

Yes, it is possible. http://code.google.com/googleapps/appsscript/articles/bracket_maker.html has a good sample, including how to add a button to a spreadsheet to run some Google Apps Script in Section 4. This can then be used to write the 0/1 to a hidden cell.

share|improve this answer

Your Answer

 
or
required, but never shown
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.