I have a Google Form that saves results to a Columns A:F of a googlesheet (called googlesheet1 in this example). I then need to import some of the data from the googlesheet1 to a second sheet (Columns C, D and F from googlesheet1 should go to columns A:C in googlesheet2). Data is manually entered into columns D:M of googlesheet2 and should be copied back to googlesheet1 (into columns I:R) with the row order preserved throughout the entire process.

I have all of this working with a series of =IMPORTRANGE formulas - but it's slow and causing lag. Is there a way to do this using a series of Google Apps scripts on the forms/sheets?

CodePudding user response：

A way to move data from one spreadsheet to another

function lfunko() {
  const sss = SpreadsheetApp.getActive();
  const dss = SpreadsheetApp.openById(gobj.globals.testsourceid);
  const ssh = sss.getSheetByName("Sheet0");
  const sshsr = 2;//row where data starts
  const ssher = 20;//row where data ends
  const sshsc = 2;//column where data starts
  const sshec = 8;//column where data ends
  const svs = ssh.getRange(sshsr,sshsc,ssher - sshsr   1, sshec - sshsc   1).getValues();
  const dsh = dss.getSheetByName("Sheet0");
  const dshsr = 4;//row where data starts in dsh
  const dshsc = 4;//column where data start in dsh
  dsh.getRange(dshsr,dshsc,svs.length,svs[0].length).setValues(svs)
}

ssh:

dsh: