Move a row from one sheet to another when a checkbox is ticked

[Kanger14]

Hello there,

I am looking for a script that would allow me to move an entire row over to another sheet when a checkbox is ticked.

I need it moved from the sheet "Call Log" to the sheet "Test" when the value in row 13 shows as TRUE (from the checkbox)

So far what I have done is essentially set up a little IF statement in column 14, where if the checkbox is ticked in 13, it writes out the word "Vape". Then I use the following script to try and pull the data:


function onEdit() {

var sheetNameToWatch = 'Call Log';

var columnNumberToWatch = 14;

var valueToWatch = "VAPE";

var sheetNameToMoveTheRowTo = 'TEST';



var ss = SpreadsheetApp.getActiveSpreadsheet();

var sheet = SpreadsheetApp.getActiveSheet();

var range = sheet.getActiveCell();



if (sheet.getName() == sheetNameToWatch && range.getColumn() == columnNumberToWatch && range.getValue() == valueToWatch) {

var targetSheet = ss.getSheetByName(sheetNameToMoveTheRowTo);

var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);

sheet.getRange(range.getRow(), 1, 1, sheet.getLastColumn()).moveTo(targetRange);

}

}


It debugs fine, but does not do what I am asking it to, so any help here is appreciated.