Google Apps Script - Append Array of Variables to Sheet

Question

I've got the following code that grabs all of the information I need form the active line, and puts them into an array of variables. However, I can't seem to find good documentation on how to append the variables to a another sheet in the same document:

function onEdit() {
var s = SpreadsheetApp.getActiveSheet();
var spreadsheetTimeZone = SpreadsheetApp.getActive().getSpreadsheetTimeZone();
var lastUpdatedString = Utilities.formatDate(new Date(), spreadsheetTimeZone, "MM/dd/yyyy' 'HH:mm:ss");
var sessionEmail = Session.getActiveUser().getEmail();

if (s.getName() == "Workload") { //checks that we're on the correct sheet
    var r = s.getActiveCell();
    if (r.getColumn() == 14) { //checks the column
        var status = r.getValue();
        var note = r.offset(0, -1);
        var noteValue = note.getValue()
        var delivery = r.offset(0, -5);
        var deliveryValue = delivery.getValue()

    }
    var array = [lastUpdatedString, sessionEmail, deliveryValue, noteValue]
    // get destination range

    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var pasteSheet = ss.getSheetByName("Historical Notes Sheet");
    var destination = pasteSheet.getRange(pasteSheet.getLastRow() + 1, 1, 1, 1);

}

}

I'd like to append the values from var array into the "Historical Notes Sheet", in the same order they are in the array.

Any help/advice you all could provide would be greatly appreciated.

Thanks!

pasteSheet.appendRow(array) developers.google.com/apps-script/reference/spreadsheet/… — Anton Dementiev
– Anton Dementiev, Commented Feb 26, 2018 at 18:27
hey @AntonDementiev, that worked great. Did you want to mark it as an answer for the rep? Thanks! — swolfe2
– swolfe2, Commented Feb 26, 2018 at 18:30

Anton Dementiev · Accepted Answer · 2018-02-26 18:31:02Z

1

Try this

pasteSheet.appendRow(array);

More info https://developers.google.com/apps-script/reference/spreadsheet/sheet#appendRow(Object)

answered Feb 26, 2018 at 18:31

Anton Dementiev

5,7344 gold badges23 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Google Apps Script - Append Array of Variables to Sheet

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related