lundi 8 juin 2020

Google Sheets button that toggles a row of checkboxes on/off

I'm very, very new to JavaScript and Google Sheets. I'm trying to learn it, but it's very confusing.

I have a row of checkboxes in Sheet1, cells E4 to L4. Below them, I have a button.

What I want to happen is, when you click the button: - If ANY of the checkboxes in cells E4 to L4 are UNCHECKED, then set them ALL to be CHECKED. - IF, however, ALL the checkboxes in E4 to L4 are already CHECKED, then set them ALL to be UNCHECKED.

This is what I have so far:

enter code herefunction ToggleALLBoxes() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName("Sheet1");

var range = sheet.getRange('E4:L4'); var value = range.getValue();

Any ideas? Thanks! --Steve




Aucun commentaire:

Enregistrer un commentaire