'How can I lock checkbox once someone ticked in Google sheet
Solution 1:[1]
Once checked stays checked
function onEdit(e) {
//e.source.toast('Entry');
const sh = e.range.getSheet();
//sh.getRange("A1").setValue(JSON.stringify(e));
if(sh.getName() == "Sheet0" && e.range.columnStart == 49 && e.range.rowStart > 1 && e.value == "FALSE" ) {
//e.source.toast('Flag1')
if(e.oldValue == "true")e.range.setValue("TRUE");
}
}
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |

