Google script (copy row to other sheet onEdit)

Question

I have this code in google sheets:

function copy(row) {
  var value = sheet.getRange(row, 1).getValue();
  sheet.getRange(row, 3).setValue(value);
}

Then i change function onEdit

function onEdit(e){
  var range = e.range;
  copy(range.getRow());
}

Now this script copy some row, who we edit.

But i needed copy this row to other sheet. And if i make like this:

function copy(row) {
  var value = sheet.getRange(row, 1).getValue();
  var sheetTo = SpreadsheetApp.openById(ID).getSheetByName(NAME);
  sheetTo.getRange(row, 3).setValue(value);
}

It is not working. (If call function from editor it working well)

Please, help

Anastasia, welcome to SO! Could you please inform us what error (if any) you've received? — Eugene, Aug 01 '16 at 09:55
i dont know where i can see errors. always it show me like popup in editor, but now i have not any — Анастасия Норцова, Aug 01 '16 at 11:15

score 2 · Accepted Answer · answered Aug 01 '16 at 15:50

2

Please try to use sourceRange.copyTo(targetRange);instead setValue

answered Aug 01 '16 at 15:50

Eugene

1,865
3
21
24

it used only in the same board – Анастасия Норцова Aug 11 '16 at 10:59
Did you try my solution? – Eugene Aug 11 '16 at 14:15

score 0 · Answer 2 · answered Nov 21 '17 at 16:35

0

You cannot refer to an external sheet for the onEdit trigger. See here: google script openById : You do not have permission to perform that action

answered Nov 21 '17 at 16:35

Andy K

99
8

Google script (copy row to other sheet onEdit)

2 Answers2

Linked