0

It's been a while since I've coded and am currently stuck with Google Sheets App Script. I want two check boxes in two different col, one checkbox for "Accepted" entries and the other for "Rejected" entries. I understand I currently have it set up incorrectly but how would I do an if else statement for determining where to input the data according to which checkbox is checked.

Here's the code below, I currently only have it working for one of the checkbox rows, it will not handle the other row of checkboxes. Currently I have the main sheet page and two other ones named "Rejected" and "Accepted" I would like to have them organize according to which checkbox is checked.

  • "Rejected" checkbox is located on column 4

  • "Accepted" checkbox is located on column 3

  • When "Accepted" checkbox is checked I would like that row of data to get copied onto the "Accepted" sheet. Same goes for the "Rejected" sheet as well with rejected data.

  • Currently checkbox only work for either "Accepted" or "Rejected" checkboxes, not both. I would like for it to work for both columns of checkboxes.

     function onEdit(e){ const src = e.source.getActiveSheet(); const r = e.range; if (src.getName() != "Suggestions" || r.columnStart != 4 || r.rowStart == 1) return; const dest = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Rejected"); src.getRange(r.rowStart,1,1,4).moveTo(dest.getRange(dest.getLastRow()+1,1,1,4)); src.deleteRow(r.rowStart); if (src.getName() != "Suggestions" || r.columnStart != 3 || r.rowStart == 1) return; const dest2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Accepted"); src.getRange(r.rowStart,1,1,4).moveTo(dest2.getRange(dest2.getLastRow()+1,1,1,4)); src.deleteRow(r.rowStart); }
Improve this question

1 Answer 1

Reset to default
1

This is what I came up with and it seems to work fine. Now that I've gotten this going, is there a way to return the data back to the main sheet if the checkbox is unchecked?

function onEdit(e){ const src = e.source.getActiveSheet(); const r = e.range; if (src.getName() == "Suggestions" && r.columnStart == 3){ const dest = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Accepted"); src.getRange(r.rowStart,1,1,4).moveTo(dest.getRange(dest.getLastRow()+1,1,1,4)); src.deleteRow(r.rowStart); } else if (src.getName() == "Suggestions" && r.columnStart == 4){ const dest = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Rejected"); src.getRange(r.rowStart,1,1,4).moveTo(dest.getRange(dest.getLastRow()+1,1,1,4)); src.deleteRow(r.rowStart); } return; }
Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

While this code snippet may be the solution, including an explanation really helps to improve the quality of your post. Remember that you are answering the question for readers in the future, and those people might not know the reasons for your code suggestion.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.