How to use google app script property service in a html applet

Question

Good morning and thank you in advance for the help. I am a noobi at java/gas scripting so any help is appreciated.

On a google spreadsheet I have a custom menu that launches a small html menu that I would like to be able to launch various web pages from. The actual addresses are variable. I have set those as Keys with the property service when the page launches.

Here is the html code (taken from another example and trying to adapt)"

<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<script type="text/javascript">

var myArr = ["Peter", "Paul", "Tony", "Adam"];
function display(name) {
var accScriptPageLinkID= PropertiesService.getScriptProperties().getProperty('scriptPageLinkAdd');
Logger.log(accScriptPageLinkID)
alert(name);
}

for(var i = 0; i < 4; i ++) {
document.write('<input type="button" onclick="display(this)" name="'+  myArr[i] + '" value="'+ myArr[i] +'">'); // Will log Peter, Paul..
}
</script>
</body>
</html>

I need to modify the above code so that when the button Peter is pressed it opens the Script Page linked under the Property Service Key 'scriptPageLinkAdd'.

Or if there is an easier way to create a dynamic html page for my menu that is linked to cells in the google spreadsheet, please advise.

Mike

azawaza · Accepted Answer · 2016-04-18 15:48:35Z

2

PropertiesService (and Logger too) are server-side AppsScript classes - they can't be invoked directly from the client side (your html page). To invoke them on the server side from your html page you must use google.script.run.withSuccessHandler(clientSideFunctionToProcessReturnedData).someServerSideFunction() which can return some data back to your html page. Learn more about HtmlService and communicating with the server here

answered Apr 18, 2016 at 15:48

azawaza

3,0941 gold badge19 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

How to use google app script property service in a html applet

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related