Complete noob here. I'm trying to build a risk matrix data collection tool with Google Sheets that can record each time a user tap a checkbox, with a prompt confirming the recording of said data. Checkbox has to uncheck itself but still record the data.
function onEdit(e) {
if(e.range.getSheet().getName()=='Sheet1') {
if(e.range.getA1Notation()=='B3' && e.value=="TRUE") {
SpreadsheetApp.getUi().alert('You've clicked B3. Your intervention has been recorded Unlikely - Minor impact');
e.range.setValue("FALSE");
}
}else{
return;
}
}
How can I add code to record each time that cell (B3 in the example) has been checked? Thanks in advance
Aucun commentaire:
Enregistrer un commentaire