Advertisement
Guest User

Untitled

a guest
Nov 28th, 2014
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. function onOpen() {
  2. var spreadsheet = SpreadsheetApp.getActive();
  3. var menuItems = [
  4. {name: 'by label', functionName: 'fShowUI'}
  5. ];
  6. spreadsheet.addMenu('Gmail export', menuItems);
  7. }
  8.  
  9. function fShowUI() {
  10. var myapp = UiApp.createApplication().setTitle('Google Mail - Label export');
  11. var mypanel = myapp.createVerticalPanel();
  12. var mylist = myapp.createListBox().setId('mylist');
  13. var mybutton = myapp.createButton('Select label').setId('mybutton');
  14.  
  15. var labels = GmailApp.getUserLabels();
  16. for (var i = 0; i < labels.length; i++) {
  17. mylist.addItem(labels[i].getName())
  18. }
  19.  
  20. callbackHandler = myapp.createServerHandler("fButtonConfirm");
  21. callbackHandler.addCallbackElement(mypanel);
  22. mybutton.addClickHandler(callbackHandler);
  23.  
  24. mypanel.add(mylist);
  25. mypanel.add(mybutton);
  26. myapp.add(mypanel);
  27.  
  28. /* Return myapp to display the UiInstance object and all elements associated with it. */
  29. var spreadsheet = SpreadsheetApp.getActive();
  30. spreadsheet.show(myapp);
  31. }
  32.  
  33. function fButtonConfirm(e) {
  34. var spreadsheet = SpreadsheetApp.getActive();
  35. spreadsheet.toast(e.parameter.mylist);
  36. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement