Breaking News: Grepper is joining You.com. Read the official announcement!

Specify parameters for menu functions in google sheet scripts

Awful Addax answered on February 16, 2023 Popularity 1/10 Helpfulness 8/10

answer Specify parameters for menu functions in google sheet scripts

Specify parameters for menu functions in google sheet scripts

Comment

class DynamicMenu {
  constructor() {      
  const mySimpleParams = [["one", "1"], ["two", {aa: "objectparam"}], ["three", [["arrayParam"]]]]

  this.createMenu = (ui) => {
    const menu = ui.createMenu('My menu')
      mySimpleParams.forEach(param=>{
          //beware to name without strange characters
          const functionName = `function${param[0]}`
          const entryName =  `option-${param[0]}`
          menu.addItem(entryName, `menuActions.${functionName}`)
      })
     menu.addToUi();
  }
  
  this.createActions = () => {
      const menuActions = {}
      mySimpleParams.forEach(param=>{
          const functionName = `function${param[0]}`
          menuActions[functionName] = function() {mayParametrizedFunction(param[1])}
      })
      return menuActions;
  }

  function mayParametrizedFunction(param) {
         SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
               .alert(`Got you folk!: ${param}`);
  }
 }
}

const menu = new DynamicMenu();
const menuActions = menu.createActions()

function onOpen() {
  menu.createMenu(SpreadsheetApp.getUi())
}

Popularity 1/10 Helpfulness 8/10 Language whatever

Source: stackoverflow.com

Tags: menu parameters whatever

Link to this answer
Share Copy Link