lundi 21 décembre 2020

Risk matrix data collection on mobile

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