Hi everyone,
I've managed to create my first Add-on for spreadsheet:
You'll find below the code structure:
The problem is I can't make it work properly by downloading it as add-on
on Chrome.
The app was approved by [email protected], they sent me an ID from
which I could download my app, which is done.
The Idea is simple, I only wanted to implement a new custom function for
spreadsheets users.
function onOpen(e) {
SpreadsheetApp.getUi().createAddonMenu()
.addItem('Start', 'use')
.addToUi();
}
/**
* Enables the add-on on for the current spreadsheet (simply by running) and
* shows a popup informing the user of the new functions that are available.
*/
function use() {
var title = "MyApp";
var message = "The Function MYFUNCTION is now available in this
spreadsheet";
var ui = SpreadsheetApp.getUi();
ui.alert(title, message, ui.ButtonSet.OK);
}
function onInstall(e) {
onOpen(e);
}
/**
* blablabla
* @param {string} input the blabla.
* @return The blabla
* @customfunction
*/
function MYFUNCTION(URL) {
return "example "+URL;
}
can anyone give me a help on this one?
Thanks in advance,
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
