V
V
vlad_sitnik2020-01-29 16:12:08
Google Sheets
vlad_sitnik, 2020-01-29 16:12:08

How to make a menu in a google spreadsheet that, when clicked, will take me to another spreadsheet?

There is such a menu. It is necessary that when I click on it, I was transferred to another table (ML 250 Cherry). How to implement it? Could you be more specific, I'm not very good at it.5e31846711166352570816.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Aleksei Shebanits, 2021-01-26
@shebanits

function onOpen() {
  SpreadsheetApp.getUi()
    .createAddonMenu()
    .addItem('goTo', 'goTo')
    .addToUi()
}

function goTo() {
  let htmlOutput = HtmlService
    .createHtmlOutput(
      `<script>
      window.open("https://google.com");
      google.script.host.close();
      </script>`)
    .setWidth(20)
    .setHeight(20);
  SpreadsheetApp.getUi().showModelessDialog(htmlOutput, 'Переход');
}

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question