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 here
function 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