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.
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.