Skip to content

Instantly share code, notes, and snippets.

@barrieroberts
Created May 7, 2017 13:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save barrieroberts/22eb198157af2958bceb4cd0622cd4e7 to your computer and use it in GitHub Desktop.
Save barrieroberts/22eb198157af2958bceb4cd0622cd4e7 to your computer and use it in GitHub Desktop.
Apps Script Basics - if, prompt, menu, & onOpen trigger (1)
function onOpen() {
SpreadsheetApp.getUi()
.createMenu('New menu')
.addItem('Example 1', 'example1')
.addItem('Example 2', 'example2')
.addItem('Example 3', 'example3')
.addItem('Example 4', 'example4')
.addItem('Example 5', 'example5')
.addItem('Example 6', 'example6')
.addItem('Return to Sheet1', 'example6b')
.addItem('Example 7', 'example7')
.addItem('Example 8', 'example8')
.addItem('Example 9', 'example9')
.addToUi();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment