metabase-google-sheets-add-on icon indicating copy to clipboard operation
metabase-google-sheets-add-on copied to clipboard

Can't see functions after publishing the add-on

Open Eliagandolfi opened this issue 3 years ago • 1 comments

If I run the script as a Google App-script, it works as great Screenshot 2021-12-30 at 15 06 37

but if I publish the add-on, the functions disappear, and I can only see the "help" option Screenshot 2021-12-30 at 15 06 47

Eliagandolfi avatar Dec 30 '21 14:12 Eliagandolfi

For reference, I solved it by tweaking the onOpen() function as below

function onOpen() {
  var ui = SpreadsheetApp.getUi().createAddonMenu();
  ui.addItem('Import Question', 'importQuestion');
  ui.addItem('Import All Questions', 'importAllQuestions');
  ui.addToUi();
}

Eliagandolfi avatar Dec 30 '21 15:12 Eliagandolfi