0

Brand new at this.

I thought the following code in Google Apps Script would simply open a sheet in another window. But nothing happened. Nothing.

Here's my code:

function OpenaSheet() {
  SpreadsheetApp.openByUrl('https://docs---------Blanked out on purpose-------------')

}
ReyAnthonyRenacia
  • 17,219
  • 5
  • 37
  • 56
weshedrick
  • 181
  • 1
  • 2
  • 10

1 Answers1

1

The SpreadsheetApp openByUrl(url) was meant to access your google spreadsheet as shown in the docs.

Another way to access your gsheet is by openById. So openByUrl doesn't literally mean it will open a provided Url but instead a means to access the spreadsheet. Check this SO post for that purpose.

ReyAnthonyRenacia
  • 17,219
  • 5
  • 37
  • 56