Google Sheets: How do I add a value at the start of a 1x2 array and shift everything right?

Question

In Google Sheets Script editor, I have the code:

function recordHistory() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("Stock History");
  var source = sheet.getRange("B2:C2");
  var values = source.getValues();
  values[0][2] = values[0][1];
  values[0][1] = values[0][0];
  values[0][0] = new Date();
  sheet.appendRow(values[0]);
};

What is the correct way to shunt values[0][0] & values[0][1] into values[0][1] & values[0][2] so I don't have to use:

  values[0][2] = values[0][1];
  values[0][1] = values[0][0];

score 0 · Answer 1 · edited May 23 '17 at 11:51

0

Google Apps Script is based on JavaScript so you could use the JavaScript array methods to achieve your goal, like unshift.

References

How can I add new array elements at the beginning of an array in JavaScript?

edited May 23 '17 at 11:51

Community

1
1

answered Aug 07 '16 at 12:55

Rubén

34,714
9
70
166

score 0 · Answer 2 · answered Aug 08 '16 at 11:36

0

Try this:

values.unshift(new Date());

It will add elements to the beginning of an array.

Hope this will help you.

Thanks.

answered Aug 08 '16 at 11:36

YNK

129
2
15

Google Sheets: How do I add a value at the start of a 1x2 array and shift everything right?

2 Answers2

References