Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function myArchive() {
- try {
- var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
- var disciplineSheet = spreadsheet.getSheetByName("Discipline");
- var archiveSheet = spreadsheet.getSheetByName("Discipline Archive");
- var disciplineConfig = spreadsheet.getSheetByName("disciplineConfig");
- for (var i = 12; i < 17; i++) {
- var readyForArchive = disciplineSheet.getRange(i, 17).getValue();
- if (readyForArchive == "Checked") {
- var disciplinary1 = disciplineConfig.getRange("I3").getFormula();
- var disciplinary2 = disciplineConfig.getRange("L3").getFormula();
- var disciplinary3 = disciplineConfig.getRange("O3").getFormula();
- var disciplinary4 = disciplineConfig.getRange("R3").getFormula();
- var disciplinary5 = disciplineConfig.getRange("U3").getFormula();
- var targetRow = archiveSheet.getLastRow() + 1;
- archiveSheet.insertRowBefore(targetRow);
- disciplineSheet.getRange(i, 14).copyTo(disciplineSheet.getRange("F5"));
- disciplineSheet.getRange("C" + i + ":P" + i).moveTo(archiveSheet.getRange(targetRow, 3));
- archiveSheet.setRowHeight(targetRow, 42);
- var date = Utilities.formatDate(new Date(), "GMT", "dd/MM/yyyy");
- archiveSheet.getRange(targetRow, 10).setValue(date);
- disciplineSheet.getRange("C16:P16").copyTo(disciplineSheet.getRange("C" + i + ":P" + i));
- var rowFormat = disciplineSheet.getRange("Q" + i);
- rowFormat.copyFormatToRange(disciplineSheet, 3, 17, i, i);
- disciplineSheet.getRange("C" + i + ":D" + i).merge();
- disciplineSheet.getRange("F" + i + ":G" + i).merge();
- disciplineSheet.getRange("K" + i + ":L" + i).merge();
- disciplineSheet.getRange("F5").copyTo(disciplineSheet.getRange(i, 14));
- disciplineSheet.getRange("F8").copyTo(disciplineSheet.getRange("F5"));
- var clearrange = disciplineSheet.getRange(i, 14);
- var clearrange1 = disciplineSheet.getRange(i, 17);
- clearrange.clearContent();
- clearrange1.clearContent();
- disciplineConfig.getRange("I3").setFormula(disciplinary1);
- disciplineConfig.getRange("L3").setFormula(disciplinary2);
- disciplineConfig.getRange("O3").setFormula(disciplinary3);
- disciplineConfig.getRange("R3").setFormula(disciplinary4);
- disciplineConfig.getRange("U3").setFormula(disciplinary5);
- }
- }
- } catch (error) {
- throw new Error("Contact RUZBE");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement