Discussions

 View Only
  • 1.  How can I incorporate Google Charts into QuickBase?

    Posted 08-15-2013 21:41
    I'm trying to incorporate Google Charts into my QuickBase application, but am having issues with the data source.


  • 2.  RE: How can I incorporate Google Charts into QuickBase?

    Posted 08-15-2013 21:45
    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.


  • 3.  RE: How can I incorporate Google Charts into QuickBase?

    Posted 08-15-2013 22:12
    Are there specific function calls and variables that I need?


  • 4.  RE: How can I incorporate Google Charts into QuickBase?

    Posted 08-15-2013 22:24
    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.


  • 5.  RE: How can I incorporate Google Charts into QuickBase?

    Posted 08-15-2013 22:56
    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;
    }


  • 6.  RE: How can I incorporate Google Charts into QuickBase?

    Posted 08-15-2013 23:15
    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.


  • 7.  RE: How can I incorporate Google Charts into QuickBase?

    Posted 03-13-2017 21:44
    Does QB have step by step instructions or a video anywhere on this?