Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function importNotes() {
- try {
- var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
- var meetingNotes = spreadsheet.getSheetByName("Meeting Notes");
- var interpol = SpreadsheetApp.openById("1KmZy7n1xM9iB1kpxTgAYjtgwjalC4-UDW1vXZ09YyRI").getSheetByName("Pyrgos");
- var sheet = interpol.getDataRange().getValues();
- var noteStart = [];
- for (var i = 1; i < sheet.length; i++) {
- if (sheet[i][1] == "Meeting Notes") {
- noteStart.push(i);
- }
- }
- var noteStart = noteStart[0] + 2;
- var noteEnd = noteStart + 12;
- var a = 9;
- for (var u = noteStart; u < noteEnd; u++) {
- var notes = interpol.getRange(u, 2).getValue();
- meetingNotes.getRange(a, 4).setValue(notes);
- a++
- }
- } catch (error) {
- throw new Error("Only C/INSP+ can add notes");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement