Is there are a way I can add arguments to a function that will be added to the Script Center Menu on a Google Spreadsheet document? This is the normal onOpen method.
function onOpen() {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
var entries = [{
name : "Summary",
functionName : "myOnOpen"
}
];
sheet.addMenu("Script Center Menu", entries);
};
I was wondering if there is something similar to the following.
function onOpen() {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
var entries = [{
name : "Summary",
functionName : "myOnOpen",
arguments : [value: "Some value"]
}
];
sheet.addMenu("Script Center Menu", entries);
};
Thanks!
I don't think that is possible exactly as you have written, but you can do it in the following way:
function onOpen() {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
var entries = [{
name : "Summary",
functionName : "myParameterisedOpen",
}
];
sheet.addMenu("Script Center Menu", entries);
};
function myParameterisedOpen() {
myOnOpen("Some value");
};
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With