App Scripts - Copy (values only) a row of data from one google spreadsheet to another (based on checked box) and deleting it from the original one

0
votes

Data Source Spreadsheet = "https://docs.google.com/spreadsheets/d/1weqJpRcou0QWpekYg-eqBXUupqSoVC5w4Tc04sFTgWs/edit?usp=sharing"

Data Destination Spreadsheet == "https://docs.google.com/spreadsheets/d/10Wa76S-slzmtCCePDChMJrLJYaAzA6H_NlpnJKWIfNU/edit?usp=sharing"

function onEdit(e){
if(e.range.columnStart != 28 || e.value != "TRUE") return;
var sh = SpreadsheetApp.getActiveSpreadsheet();
var source = sh.getSheetByName("Sheet1");
var dest = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/10Wa76S-slzmtCCePDChMJrLJYaAzA6H_NlpnJKWIfNU/edit').getSheetByName("Completed");
dest.activate().getRange(dest.getLastRow()+1,1,1,25).setValues(source.getRange(e.range.rowStart,1,1,25).getValues());
source.deleteRow(e.range.rowStart);
}
1
google-apps-scriptgoogle-sheets
What's the question? – Cooper
Welcome to StackOverFlow please take this opportunity to take the tour and learn how to How to Ask, format code, minimal reproducible example and Tag Info – Cooper

1 Answers

1
votes

I guessing that this is probably what you want:

function onMyEdit(e){
  const sh=e.range.getSheet();
  if(sh.getName()=='Sheet1' && e.range.columnStart == 28 && e.value == "TRUE") {
    const dsh=SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/10Wa76S-slzmtCCePDChMJrLJYaAzA6H_NlpnJKWIfNU/edit').getSheetByName("Completed");
    dsh.getRange(dsh.getLastRow()+1,1,1,25).setValues(sh.getRange(e.range.rowStart,1,1,25).getValues());
    sh.deleteRow(e.range.rowStart);
  }
}

It needs to be an installable onedit trigger because it requires permission to move and delete data.

Reference: