Return to Answer

added 125 characters in body

edited Apr 10, 2019 at 19:53

user555121

I'm not sure when they did it, but they've added this now.

Use class DataValidationBuilder's requireCheckbox()requireCheckbox() method. Example:

function setCheckboxes() { // Assumes there's only one sheet var sheet = SpreadsheetApp.getActiveSheet(); // This represents ALL the data var dataRange = sheet.getDataRange(); /* Get checkbox range from sheet data range. Assumes checkboxes are on the left-most column */ var dataRangeRow = dataRange.getRow(); var dataRangeColumn = dataRange.getColumn(); var dataRangeLastRow = dataRange.getLastRow(); var checkboxRange = sheet.getRange( dataRangeRow, dataRangeColumn, dataRangeLastRow ); var enforceCheckbox = SpreadsheetApp.newDataValidation(); enforceCheckbox.requireCheckbox(); enforceCheckbox.setAllowInvalid(false); enforceCheckbox.build(); checkboxRange.setDataValidation(enforceCheckbox); }

I'm not sure when they did it, but they've added this now. Use class DataValidationBuilder's requireCheckbox() method. Example:

function setCheckboxes() { // Assumes there's only one sheet var sheet = SpreadsheetApp.getActiveSheet(); // This represents ALL the data var dataRange = sheet.getDataRange(); /* Get checkbox range from sheet data range. Assumes checkboxes are on the left-most column */ var dataRangeRow = dataRange.getRow(); var dataRangeColumn = dataRange.getColumn(); var dataRangeLastRow = dataRange.getLastRow(); var checkboxRange = sheet.getRange( dataRangeRow, dataRangeColumn, dataRangeLastRow ); var enforceCheckbox = SpreadsheetApp.newDataValidation(); enforceCheckbox.requireCheckbox(); enforceCheckbox.setAllowInvalid(false); enforceCheckbox.build(); checkboxRange.setDataValidation(enforceCheckbox); }

I'm not sure when they did it, but they've added this now.

Use class DataValidationBuilder's requireCheckbox() method. Example:

function setCheckboxes() { // Assumes there's only one sheet var sheet = SpreadsheetApp.getActiveSheet(); // This represents ALL the data var dataRange = sheet.getDataRange(); /* Get checkbox range from sheet data range. Assumes checkboxes are on the left-most column */ var dataRangeRow = dataRange.getRow(); var dataRangeColumn = dataRange.getColumn(); var dataRangeLastRow = dataRange.getLastRow(); var checkboxRange = sheet.getRange( dataRangeRow, dataRangeColumn, dataRangeLastRow ); var enforceCheckbox = SpreadsheetApp.newDataValidation(); enforceCheckbox.requireCheckbox(); enforceCheckbox.setAllowInvalid(false); enforceCheckbox.build(); checkboxRange.setDataValidation(enforceCheckbox); }

Minor formatting

Source Link

edited Jul 20, 2018 at 0:51

Stephen Rauch ♦

50.1k
32
118
143

I'm not sure when they did it, but they've added this now. Use class DataValidationBuilder's requireCheckbox()DataValidationBuilder's requireCheckbox() method. Example:

function setCheckboxes() { // Assumes there's only one sheet var sheet = SpreadsheetApp.getActiveSheet(); // This represents ALL the data var dataRange = sheet.getDataRange(); /* Get checkbox range from sheet data range. Assumes checkboxes are on the left-most column */ var dataRangeRow = dataRange.getRow(); var dataRangeColumn = dataRange.getColumn(); var dataRangeLastRow = dataRange.getLastRow(); var checkboxRange = sheet.getRange( dataRangeRow, dataRangeColumn, dataRangeLastRow ); var enforceCheckbox = SpreadsheetApp.newDataValidation(); enforceCheckbox.requireCheckbox(); enforceCheckbox.setAllowInvalid(false); enforceCheckbox.build(); checkboxRange.setDataValidation(enforceCheckbox); }

I'm not sure when they did it, but they've added this now. Use class DataValidationBuilder's requireCheckbox() method. Example:

function setCheckboxes() { // Assumes there's only one sheet var sheet = SpreadsheetApp.getActiveSheet(); // This represents ALL the data var dataRange = sheet.getDataRange(); /* Get checkbox range from sheet data range. Assumes checkboxes are on the left-most column */ var dataRangeRow = dataRange.getRow(); var dataRangeColumn = dataRange.getColumn(); var dataRangeLastRow = dataRange.getLastRow(); var checkboxRange = sheet.getRange( dataRangeRow, dataRangeColumn, dataRangeLastRow ); var enforceCheckbox = SpreadsheetApp.newDataValidation(); enforceCheckbox.requireCheckbox(); enforceCheckbox.setAllowInvalid(false); enforceCheckbox.build(); checkboxRange.setDataValidation(enforceCheckbox); }

I'm not sure when they did it, but they've added this now. Use class DataValidationBuilder's requireCheckbox() method. Example:

function setCheckboxes() { // Assumes there's only one sheet var sheet = SpreadsheetApp.getActiveSheet(); // This represents ALL the data var dataRange = sheet.getDataRange(); /* Get checkbox range from sheet data range. Assumes checkboxes are on the left-most column */ var dataRangeRow = dataRange.getRow(); var dataRangeColumn = dataRange.getColumn(); var dataRangeLastRow = dataRange.getLastRow(); var checkboxRange = sheet.getRange( dataRangeRow, dataRangeColumn, dataRangeLastRow ); var enforceCheckbox = SpreadsheetApp.newDataValidation(); enforceCheckbox.requireCheckbox(); enforceCheckbox.setAllowInvalid(false); enforceCheckbox.build(); checkboxRange.setDataValidation(enforceCheckbox); }

Source Link

answered Jul 20, 2018 at 0:33

Andrew Miller

I'm not sure when they did it, but they've added this now. Use class DataValidationBuilder's requireCheckbox() method. Example:

function setCheckboxes() { // Assumes there's only one sheet var sheet = SpreadsheetApp.getActiveSheet(); // This represents ALL the data var dataRange = sheet.getDataRange(); /* Get checkbox range from sheet data range. Assumes checkboxes are on the left-most column */ var dataRangeRow = dataRange.getRow(); var dataRangeColumn = dataRange.getColumn(); var dataRangeLastRow = dataRange.getLastRow(); var checkboxRange = sheet.getRange( dataRangeRow, dataRangeColumn, dataRangeLastRow ); var enforceCheckbox = SpreadsheetApp.newDataValidation(); enforceCheckbox.requireCheckbox(); enforceCheckbox.setAllowInvalid(false); enforceCheckbox.build(); checkboxRange.setDataValidation(enforceCheckbox); }

Collectives™ on Stack Overflow

Return to Answer