Za google sheets u extensions pa apps script

 avatar
unknown
plain_text
a year ago
935 B
12
Indexable
function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Custom Menu')
    .addItem('Add Checkboxes', 'addCheckboxes')
    .addToUi();
}

function addCheckboxes() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getRange(1, sheet.getLastColumn() + 1, sheet.getLastRow());
  range.insertCheckboxes();
  
  // Apply conditional formatting
  var rule = SpreadsheetApp.newConditionalFormatRule()
    .whenFormulaSatisfied('=$' + getColLetter(range.getColumn()) + '1=TRUE')
    .setBackground('#00FF00') // Green color
    .setRanges([range])
    .build();
  
  var rules = sheet.getConditionalFormatRules();
  rules.push(rule);
  sheet.setConditionalFormatRules(rules);
}

function getColLetter(col) {
  var letter = '';
  while (col > 0) {
    var temp = (col - 1) % 26;
    letter = String.fromCharCode(temp + 65) + letter;
    col = (col - temp - 1) / 26;
  }
  return letter;
}
Editor is loading...
Leave a Comment