Google Sheets - When clicking on a checkbox, I want the row to be cleared (not deleted), and also for the checkbox to then reset

user_19418551 0
Viewed 45

I've been trying to figure this one out and I'm a bit lost...

This is what I have so far:

function deleteCheckedBoxes() {

const sheet = SpreadsheetApp.getActiveSheet();

const activeRange = sheet.getActiveRange();
const activeRow = activeRange.getRow();
const activeColumn = activeRange.getColumn();

let rangeUpdatedValue =  activeRange.getValue();

if(activeColumn == 5 && rangeUpdatedValue == true){

 sheet.deleteRow(activeRow);

};
  
}

How can I get it to clear the row instead of deleting it?

I have tried clearContent & ClearContents, but it doesn't seem to work

Any help would be greatly appreciated!

google-apps-script javascript
2 Answers

When your showing script is modified, how about the following modification?

From:

sheet.deleteRow(activeRow);

To:

sheet.getRange(activeRow, 1, 1, sheet.getLastColumn()).clearContent();
  • When this modified script is run, the row of the active range is cleared.
  • In this case, by clearContent(), the checkbox is unchecked.

Reference:

user_71086530 
function deleteCheckedBoxes() {

const sheet = SpreadsheetApp.getActiveSheet();

const activeRange = sheet.getActiveRange();
const activeRow = activeRange.getRow();
const activeColumn = activeRange.getColumn();

let rangeUpdatedValue =  activeRange.getValue();

if(activeColumn == 5 && rangeUpdatedValue == true){

 sheet.getRange(activeRow, 1, 1, sheet.getLastColumn()).clearContent();


};
  
}
user_190874180
Related