Answer the question
In order to leave comments, you need to log in
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.
Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question