else if ( e.parameter.FN == "MoveData" ) { var ssm = SpreadsheetApp.getActiveSpreadsheet(); var AppDataSheet = ssm.getSheetByName("AppData"); var TransferDataSheet = ssm.getSheetByName("TransferData"); var inputMove = e.parameter.TOMOVE; var inputWhere = e.parameter.TOWHERE; var data = AppDataSheet.getDataRange().getValues(); var newData = []; for (var i = 0; i < data.length; i++) { if (data[i][1] == inputMove) { newData.push([data[i][0], inputWhere, data[i][2], data[i][3]]); AppDataSheet.deleteRow(i+1); i--; } } TransferDataSheet.getRange(TransferDataSheet.getLastRow()+1, 1, newData.length, newData[0].length).setValues(newData); data = TransferDataSheet.getDataRange().getValues(); newData = []; for (var i = 0; i < data.length; i++) { if (data[i][1] == inputWhere) { newData.push([data[i][0], inputMove, data[i][2], data[i][3]]); TransferDataSheet.deleteRow(i+1); i--; } } AppDataSheet.getRange(AppDataSheet.getLastRow()+1, 1, newData.length, newData[0].length).setValues(newData); return ContentService.createTextOutput("Diere is geskuif"); }