RemcoE33

mactaff checkboxes

Jun 26th, 2021 (edited)
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function onEdit(e) {
  2.   if (e.range.getSheet().getName() != 'Data') { return; }
  3.   if (e.range.columnStart == 3 && e.value == "TRUE") {
  4.     e.range.offset(0, 1).setValue(new Date());
  5.   } else if (e.range.columnStart == 3 && e.value == "FALSE") {
  6.     e.range.offset(0, 1).clearContent();
  7.   } else if (e.range.columnStart == 3){
  8.      e.range.insertCheckboxes()
  9.      if (!e.range.offset(0,1).isBlank()){
  10.        e.range.setValue(true)
  11.      }
  12.   }
  13. }
  14.  
  15. /* not working onEdit(e) script */
  16. function onEdit(e) {
  17.   if (e.range.getSheet().getName() != 'Data') { return; }
  18.   const activeSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet()
  19.   const activeSelection = activeSheet.getSelection().getActiveRange()
  20.   const activeA1 = activeSelection.getA1Notation()
  21.   console.log(activeA1)
  22.   if (e.range.columnStart == 3 && e.value == "TRUE") {
  23.     activeSheet.getRange(activeA1).offset(0, 1).setValue(new Date());
  24.   } else if (e.range.columnStart == 3 && e.value == "FALSE") {
  25.     activeSheet.getRange(activeA1).offset(0,1).clearContent();
  26.   } else if (e.range.columnStart == 3){
  27.      e.range.insertCheckboxes()
  28.      const offsetValues = activeSelection.getValues().flat()
  29.      for(i = 0; i < offsetValues.length; i++){
  30.        if (offsetValues[i] != ''){
  31.          e.range.offset(i,0).setValue(true)
  32.        }
  33.      }
  34.   }
  35. }
  36.  
  37. /* Run this via -> Macro -> import and then Marcro -> Run */
  38. function func(){
  39.   const a1 = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getSelection().getActiveRange().getA1Notation()
  40.   Browser.msgBox(a1)
  41. }
Add Comment
Please, Sign In to add comment