Adding a simple menu of scripts on your spreadsheet goes something like this:
1 2 3 4 5 6 7 8 9 10 11 |
function onOpen() { //creates custom menu SpreadsheetApp.getUi() .createMenu('Comms Scripts') .addItem('Go to Last Entry in Database', 'getLastDatabaseEntry') .addItem('Remove Completed Entries', 'moveCompleted') .addItem('Format Cells', 'onFormSubmit') .addToUi(); } |
The first part in ” is what appears on the menu, the second part is the function you are calling. Placing this code in the onOpen function automagically creates the menu each time you start or refresh your google sheet