Skip to content

Instantly share code, notes, and snippets.

@dimitrispaxinos

dimitrispaxinos/AddMenuAndShowMessageFunction.js

Created September 30, 2023 07:52
Show Gist options
  • Save dimitrispaxinos/fdb10543bd223fc71a986f09fac36958 to your computer and use it in GitHub Desktop.
Save dimitrispaxinos/fdb10543bd223fc71a986f09fac36958 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
AddMenuAndShowMessageFunction.js
function onOpen() {
const ui = SpreadsheetApp.getUi();
ui.createMenu('Settings')
.addItem('Show Message', 'showMessage')
.addToUi();
}
function showMessage() {
if (settings.getBooleanSetting("ShowModal")) {
const message = settings.getSetting("ModalMessage");
SpreadsheetApp.getUi().alert(message);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment