How to pass parameters with menu items in apps script [duplicate]

Question

I have some information that I would like to push from a primary google sheet to other sheets which I need to select, I would like to turn this into a menu item so I've added:

  ui.createMenu('Push to Sheet').addItem('Select Sheet', 'myFunction').addToUi();

I have a complicated function that starts with:

function myFunction(PARAM1,  PARAM2) {

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  .......

I'm not clear How to pass parameters to the function using this technique. How can I get this working?

Related: stackoverflow.com/questions/20872214/… stackoverflow.com/questions/46529007/… stackoverflow.com/questions/23823558/… stackoverflow.com/questions/50946493/… (and so on) — tehhowch
– tehhowch, Commented Aug 13, 2018 at 14:52

TheWizEd · Accepted Answer · 2018-08-13 15:43:28Z

4

There is no way to pass a parameter to the function associated with a menu item. Not sure why you would. Unless you have more than one menu item that uses the same function and you are trying to determine which menu item was selected. In that case you would need a wrapper function something like myFunction1(), myFunction2(), etc. linked to each menu item individually. Then within myFunction1() you call myFunction(1).

answered Aug 13, 2018 at 15:43

TheWizEd

8,6542 gold badges14 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user1592380 Over a year ago

Yes , your example is my use case. You give an example in code? I have a follow up at stackoverflow.com/questions/51826107/…

user1592380 Over a year ago

Heres is example of how to do it: stackoverflow.com/questions/51827523/…

camursm Over a year ago

"Not sure why you would"? Use one function to process menu items.

sandalwoodsh · Accepted Answer · 2019-12-20 20:25:19Z

0

While there is no way to pass arguments to your newly created function, you can however pass in simple global variables, but they have to be defined at the root level and they cannot be altered by any means from any subsequent functions.

i.e. if you defined the following in the root script

var folderToSearch = ['folderIDString']

You could pick that up in your

newCreatedMenuFunction () {
Logger.log("folderToSearch: " + folderToSearch);
}

Output 'folderIDString'

Not that it does you much good, but some parameters are possible. You might have to rethink what it is you are trying to achieve.

answered Dec 20, 2019 at 20:25

sandalwoodsh

2414 silver badges16 bronze badges

Collectives™ on Stack Overflow

How to pass parameters with menu items in apps script [duplicate]

2 Answers 2

3 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Linked

Related