Need to open the spreadsheet while copying from another account

Question

I am trying to copy the sheet from one account from another account while accessing google form. I am able to copy the sheet by using below Appscript. But i need to open the same while copying itself. Currently able open by manually.

function myFunction() {

 var app=SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1DpeqCN2Bm2pWxf4TiMEa53xM6MEhSx8GfP6CuyI/edit#gid=0");
 app.copy("NewSheettest19");
}

Answer 1

Opening the file in user context

You can't trigger a script on form submission that runs in the user context. Installed triggers run with the owner's privileges. This could result in security issues. You may email the user with the link or insert it in a shared spreadsheet cell. But you cannot access the user interface in this context.

Please look at this answer for additional information: https://stackoverflow.com/a/26978896.

Opening the file in the editor context:

You won't be able to open the copied file directly from Apps Script. You can use though a workaround building a user interface that uses javascript to open a new page, navigating to your recently copied spreadsheet file.

Code:

var app=SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1DpeqCN2Bm2pWxf4TiMEa53xM6MEhSx8GfP6CuyI/edit#gid=0");
var copied = app.copy("NewSheettest19");
var html = "<script>window.open('" + copied.getUrl() + "');google.script.host.close();</script>";
var userInterface = HtmlService.createHtmlOutput(html);
FormApp.getUi().showModalDialog(userInterface, "Opening Copied Sheet... ");

This code will create a custom dialog containing the Javascript to open the new Spreadsheet and then it will close the dialog.

References:

G Suite Docs Dialogs

Window.open()