Skip to content Skip to sidebar Skip to footer

Appending Row With Checkbox In Google Scripts

Im writing a small google script for an excel sheet which appends a row on a POST request: depending on the POST parameters I either append the row to the end, or I insert it in be

Solution 1:

You need to create a checkbox first with data validation

Sample:

 var checkbox = SpreadsheetApp.newDataValidation().requireCheckbox().build();
 sheet.getRange("C" + (position)).setDataValidation(checkbox).setValue("FALSE");

Post a Comment for "Appending Row With Checkbox In Google Scripts"