Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2019
468
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. function onOpen() {
  2. var ui = SpreadsheetApp.getUi();
  3. ui.createMenu('Scripts')
  4. .addItem('Open Create', 'openCreate')
  5. .addItem('Open Perform', 'openPerform')
  6. .addItem('Open Catalog', 'openCatalog')
  7. .addToUi();
  8. }
  9. function openCreate() {
  10. var ss = SpreadsheetApp.openById("create ID goes here");
  11. }
  12. function openPerform() {
  13. var ss = SpreadsheetApp.openById("perform ID goes here");
  14. }
  15. function openCatalog() {
  16. var ss = SpreadsheetApp.openById("catalog ID goes here");
  17. }
  18.  
  19. function onOpen() {
  20. var ui = SpreadsheetApp.getUi();
  21. ui.createMenu('Custom Menu')
  22. .addItem('Website', 'openSite')
  23. .addToUi();
  24. }
  25. function openSite() {
  26. var selection = SpreadsheetApp.getActiveSheet();
  27. var html = "<a href='url'; target='_blank'>Open Site</a>";
  28. var userInterface = HtmlService.createHtmlOutput(html);
  29. SpreadsheetApp.getUi().showModalDialog(userInterface, 'Open Google Site');
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement