Creating a dashboard that uses Spreadsheet as Database

[Joel]

Currently I am only able to create a local database, can anyone direct me as to how I can go about creating a dashboard that uses a google spreadsheet as a database.

[Daniel LaLiberte]

Joel,

To use a google spreadsheet as your data, you should be able to follow the instructions at https://developers.google.com/chart/interactive/docs/spreadsheets

One example is shown in the Playground: https://code.google.com/apis/ajax/playground/?type=visualization#data_source_request

but it works with an IntensityMap not in a dashboard.

To use spreadsheet data with a dashboard is very similar to using local data.   The complication is that you will have to wait for the data to be returned, when your handler is called, before you can proceed with drawing the dashboard.   Hope that helps.  I can put together an example if you are still having trouble.

dan

On Thu, Jan 17, 2013 at 2:42 AM, Joel <saber...@hotmail.com> wrote:

Currently I am only able to create a local database, can anyone direct me as to how I can go about creating a dashboard that uses a google spreadsheet as a database.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/lxHCIsGmhpMJ.
To post to this group, send email to google-visua...@googlegroups.com.
To unsubscribe from this group, send email to google-visualizati...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

--

Daniel LaLiberte  - 978-394-1058

dlaliberte@Google.com   562D 5CC, Cambridge MA

daniel.laliberte@GMail.com 9 Juniper Ridge Road, Acton MA

[Joel]

Hi Daniel,

Thank you so much for your reply.

I've found what I;m looking for. Really appreciate your help :)))

On Thursday, January 17, 2013 9:43:21 PM UTC+8, Daniel LaLiberte wrote:

Joel,

To use a google spreadsheet as your data, you should be able to follow the instructions at https://developers.google.com/chart/interactive/docs/spreadsheets

One example is shown in the Playground: https://code.google.com/apis/ajax/playground/?type=visualization#data_source_request

but it works with an IntensityMap not in a dashboard.

To use spreadsheet data with a dashboard is very similar to using local data.   The complication is that you will have to wait for the data to be returned, when your handler is called, before you can proceed with drawing the dashboard.   Hope that helps.  I can put together an example if you are still having trouble.

dan

On Thu, Jan 17, 2013 at 2:42 AM, Joel <saber...@hotmail.com> wrote:

Currently I am only able to create a local database, can anyone direct me as to how I can go about creating a dashboard that uses a google spreadsheet as a database.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/lxHCIsGmhpMJ.
To post to this group, send email to google-visua...@googlegroups.com.

To unsubscribe from this group, send email to google-visualization-api+unsub...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

--

Daniel LaLiberte  - 978-394-1058

dlali...@Google.com   562D 5CC, Cambridge MA

daniel.l...@GMail.com 9 Juniper Ridge Road, Acton MA

[Matt]

Hi Joel.

Did you find any explanation on how to create a google dashboard using data stored in a google spreadsheet?

I've been looking for such example for a long time now and I don't seem to find anything like that. All articles and docs refer to using a local table.

Please advise.

Thank you so much.

Martt

[asgallant]

Basically, a Dashboard drawn from a data source (like a Google spreadsheet) is fundamentally no different than a Dashboard drawn from a locally-defined DataTable.  The only difference is in how you obtain the DataTable to draw the Dashboard with.

Here's a simple example: http://jsfiddle.net/asgallant/YNaGh/.

[Martin Monsalvo]

Thank you Drew.

That's all I needed.

Regards.

Mattt

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/IaSKaUe6iJI/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to google-visualizati...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.

Visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.