Trying to figure out Google Apps Script for making Google docs addons. I have:
function helloWorld() {
return "Hello World";
}
under code.gs which I call in:
console.log("This should say Hello World: " + google.script.run.helloWorld())
It returns:
This should say Hello World: undefined
What is the obvious thing I am missing?
google.script.run
won't return a value like you'd expect a usual Apps Script function to. Instead, you should use .withSuccessHandler(functionToRun)
Like this:
google.script.run
.withSuccessHandler(functionToRun)
.helloWorld();
function functionToRun(argument) {
console.log("This should say Hello World: " + argument);
}
In this example, the server-side Apps Script function helloWorld
will run the client-side function functionToRun()
and pass the result of helloWorld()
as an argument.
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