Skip to main content
Question

How can I incorporate Google Charts into QuickBase?

  • August 16, 2013
  • 0 replies
  • 61 views

I'm trying to incorporate Google Charts into my QuickBase application, but am having issues with the data source.
This topic has been closed for replies.

  • Registered
  • August 16, 2013
Retrieve your data using ?act=API_GenResultsTable&jsa=1 and your data will be in an array named qdb_data. You can then reduce the data using Underscore. This general procedure will produce data in the array format Goolgle Visualization requires.

  • Author
  • Registered
  • August 16, 2013
Are there specific function calls and variables that I need?

  • Registered
  • August 16, 2013
You question is too broad as I don't know what you want to acheive. The Vandelay Industries example was created using Google Visualization:

https://haversineconsulting.quickbase.com/db/bhf8pmjat

I had a writeup on this example on the posterous blog but twitter purchased posterous and shut it down.

  • Author
  • Registered
  • August 16, 2013
Thanks.  My question is basically how to implement the API call.  Would I create the report first in QuickBase and then grab the URL from that report; then incorporate that URL in the result below?

function doGet(){
  var result = UrlFetchApp.fetch('?act=API_GenResultsTable&jsa=1');
  var json = Utilities.jsonParse(result.getContentText());
  var top_users = json.top_users;
}

  • Registered
  • August 16, 2013
Your code appears to be using some Google libraries to make the HTTP request for the QuickBase data. Just use jQuery instead. This code fragment queries table dbid for the query with qid=17 and returns the results as an array named qdb_data:

var dbid="????????";$.getScript(dbid + "?act=API_GenResultsTable&qid=17&jsa=1",function(){ console.log(qdb_data);});

You would manipulate the array qdb_data into the datatable required by Google Visualization.

Does QB have step by step instructions or a video anywhere on this?