How to pass values from ScriptDb to Google Sites gadget

Question

I have a Google Sites page with an embedded Apps Script gadget. On the page, I want to display ScriptDb data upon clicking a button.

My question is: how can I pass ScriptDb results to the JavaScript embedded in my gadget?

Here is my source:

[Sample-Code.gs]

function doGet() {
  // return template page
  return HtmlService
      .createTemplateFromFile('Sample-HTML')
      .evaluate().setSandboxMode(HtmlService.SandboxMode.NATIVE);
}

function include(filename) {
  return HtmlService.createHtmlOutputFromFile(filename)
      .getContent();
}

// assume db contains 10 'records'
function getData(query) {
  var db = ScriptDb.getMyDb(); 
  var data = db.query(query);
  Logger.log(data.getSize()); // returns '10.0'
  return data; // makes showData think this is null
}

[Sample-HTML.html]

<?!= include('Sample-JavaScript'); ?>

<input type="button" value="show data"
    onclick="google.script.run
    .withSuccessHandler(showData)
    .getData({})" />

[Sample-JavaScript.html]

<script>
function showData(db_query_result) {
alert(db_query_result); // returns null.
}
</script>

ScriptDB was deprecated

Wicket
– Wicket

2017-06-19 00:11:43 +00:00
Commented Jun 19, 2017 at 0:11 — Wicket
– Wicket, Commented Jun 19, 2017 at 0:11

Serge insas · Accepted Answer · 2013-09-29 10:30:40Z

1

The value returned by db.query() is an object as defined in the documentation that can not be used directly in your UI, you should return the value in a format that can be shown in the page : a string or an array of strings.

I didn't test but this should work :

function getData(query) {
  var db = ScriptDb.getMyDb(); 
  var result = db.query(query);
  Logger.log(result.getSize()); // returns '10.0'
  var results = db.query({type: 'person'});
  var data = [];
  while (results.hasNext()) {
   data.push(results.next());
  }
  return data; // data is an array of results
}

answered Sep 29, 2013 at 10:30

Serge insas

46.9k7 gold badges113 silver badges135 bronze badges

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

3 Comments

Serge insas Over a year ago

Thanks, I guess the guy won't show up anymore.. september '13 ;-)

Rno Over a year ago

A very belated thank you, Serge :) Not quite got the hang of stackoverflow etiquette. It's all water under the bridge now as Google pulled the plug on ScriptDb.

Serge insas Over a year ago

Thanks (better late than never :-), yes indeed unfortunately..., I sort of liked it ;)

Collectives™ on Stack Overflow

How to pass values from ScriptDb to Google Sites gadget

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related