How to move data from one spreadsheet to an entirely separate spreadsheet via Apps Script.
Important Notes:
* As with all on edit scripts, this script is not meant to be run manually but runs automatically from the trigger.
* This must be done with an installed trigger; a simple onEdit(e) trigger cannot access another spreadsheet
* The format is destination_sheet.getRange(full row).setValues(source_sheet.getRange(full row))
Sheets (to copy)
New https://docs.google.com/spreadsheets/d/1nqT55I54lEaoa-L6gFMvxBekEoRHSbfiED9cvDWdA9A/edit#gid=0
Complete https://docs.google.com/spreadsheets/d/1ca2AH1NpyYGVb-879kQ4COY_Kv1quGdnZL8r0B1YVhw/edit#gid=0
Script:
function moveRowOnCheck(e) {
const src = e.source.getActiveSheet();
const r = e.range;
if (r.columnStart != 3 || r.rowStart == 1 || e.value != "TRUE") return;
const dest = SpreadsheetApp.openById("1ca2AH1NpyYGVb-879kQ4COY_Kv1quGdnZL8r0B1YVhw").getSheets()[0];
dest.getRange(dest.getLastRow() + 1, 1, 1, 3).setValues(r.offset(0, -2, 1, 3).getValues());
src.deleteRow(r.rowStart);
}
Connect with me:
• [email protected]
• spencerfarris.me
• www.linkedin.com/in/spencer-farris/
• Twitter @FarrisSpencer
• Google Product Expert support.google.com/docs/profile/12305
