google.visualization chart - DataTable in google site

1
votes

I'm not understand how to implement chart in Google site. My goal is to show spreadsheet. I'm choose to use the charts from google.visualization.DataTable with dashboard.

This is my steps:

1) Create new project from apps script project.

2) add file Code.gs:

function doGet() {
 return HtmlService.createTemplateFromFile('myPage').evaluate();
}

3) add file myPage.html i take the example from https://developers.google.com/chart/interactive/docs/gallery/controls?hl=en

I'm add to body "Hello world!" for test.

4) test this HTML code in Google play ground (all work fine)

5) Go to the edit page in my Google site and add this script to page Insert -> Apps script gadget

6) Save, Reload

As result in my page I see "Hello world!" but table is absent! What is wrong? What is the bast way to show table from Google spreadsheet with filers?

2
google-apps-scriptgoogle-apigoogle-visualization

2 Answers

1
votes

See the docs about caja and htmlservice. Those Chart libs are not supported.

0
votes

Zig is right, caja does not support google.visualization libs so far.

What you need is to use the Charts module in GAS UiApp: https://developers.google.com/apps-script/reference/charts/

You can create data table and dashboard. They will look the same as if you have used google.visualization.

Best,

Thierry