Using the Code Below which works I need to add another function that does everything the else if statement does but rather then moving the entire row of data to another sheet I only need to move data from cell A.
I also need to add a function that will move the entire row of data if a checkbox is checked.
function onEdit(e) {
if (e.value === 'COMPLETED FAB') {
var sheet = e.range.getSheet();
if (sheet.getSheetName() == 'Fabrication') {
logSheet = e.source.getSheetByName('Fabrication Completed');
var row = e.range.getRow();
var lastRow = logSheet.getLastRow();
var range = sheet.getRange(row, 1, 1, sheet.getLastColumn());
range.copyTo(logSheet.getRange(lastRow + 1, 1));
sheet.deleteRow(row);
}
}
else if (e.value === 'FINISHED') {
var sheet = e.range.getSheet();
if (sheet.getSheetName() == 'Service') {
logSheet = e.source.getSheetByName('Service Completed');
var row = e.range.getRow();
var lastRow = logSheet.getLastRow();
var range = sheet.getRange(row, 1, 1, sheet.getLastColumn());
range.copyTo(logSheet.getRange(lastRow + 1, 1));
sheet.deleteRow(row);
}
}
else if (e.value === 'SURV COMP') {
var sheet = e.range.getSheet();
if (sheet.getSheetName() == 'Surveys') {
logSheet = e.source.getSheetByName('Surveys Completed');
var row = e.range.getRow();
var lastRow = logSheet.getLastRow();
var range = sheet.getRange(row, 1, 1, sheet.getLastColumn());
range.copyTo(logSheet.getRange(lastRow + 1, 1));
sheet.deleteRow(row);
}
}
}
Aucun commentaire:
Enregistrer un commentaire