Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit(e) {
- if (e.range.getSheet().getName() != 'Data') { return; }
- if (e.range.columnStart == 3 && e.value == "TRUE") {
- e.range.offset(0, 1).setValue(new Date());
- } else if (e.range.columnStart == 3 && e.value == "FALSE") {
- e.range.offset(0, 1).clearContent();
- } else if (e.range.columnStart == 3){
- e.range.insertCheckboxes()
- if (!e.range.offset(0,1).isBlank()){
- e.range.setValue(true)
- }
- }
- }
- /* not working onEdit(e) script */
- function onEdit(e) {
- if (e.range.getSheet().getName() != 'Data') { return; }
- const activeSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet()
- const activeSelection = activeSheet.getSelection().getActiveRange()
- const activeA1 = activeSelection.getA1Notation()
- console.log(activeA1)
- if (e.range.columnStart == 3 && e.value == "TRUE") {
- activeSheet.getRange(activeA1).offset(0, 1).setValue(new Date());
- } else if (e.range.columnStart == 3 && e.value == "FALSE") {
- activeSheet.getRange(activeA1).offset(0,1).clearContent();
- } else if (e.range.columnStart == 3){
- e.range.insertCheckboxes()
- const offsetValues = activeSelection.getValues().flat()
- for(i = 0; i < offsetValues.length; i++){
- if (offsetValues[i] != ''){
- e.range.offset(i,0).setValue(true)
- }
- }
- }
- }
- /* Run this via -> Macro -> import and then Marcro -> Run */
- function func(){
- const a1 = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getSelection().getActiveRange().getA1Notation()
- Browser.msgBox(a1)
- }
Add Comment
Please, Sign In to add comment