google-apps-script - 谷歌表格 : Prevent the unchecking of a checkbox after it has been checked

Question

是否有条件语句或公式来防止在用户选中复选框后取消选中复选框？

Answer 1

解决方案:
您可以利用 Class Protection如果选中复选框，则保护单元格；值变为 TRUE .

function onEdit(e) {

  const row = e.range.getRow();
  const col = e.range.getColumn();
  const as = e.source.getActiveSheet();

  if(as.getName() == "Sheet1" && col == 2 && row > 1 && e.range.getValue()===true) {  
     
   const protection = as.getRange(row,col).protect();
    
  // Ensure the current user is an editor before removing others. Otherwise, if the user's edit
  // permission comes from a group, the script throws an exception upon removing the group.
   const me = Session.getEffectiveUser();
   protection.addEditor(me);
   protection.removeEditors(protection.getEditors());
   if (protection.canDomainEdit()) {
  protection.setDomainEdit(false);
  }
    
  }
}

随意修改"Sheet1"和 col == 2 ( 2 对应
栏目 乙 )。

要启用此代码片段，复制和粘贴 它到脚本编辑器
( Tools => Script Editor ) 然后点击 保存 .

例子: