Forum Discussion

_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
12 years ago

How To Create Org Charts In A Jiffy?

Over on the QuickBase Tools Linkedin page someone asked how to generate an org chart in QuickBase. Twenty minutes later we have a simple solution:

ACME Inc Org Chart List All
https://www.quickbase.com/db/bhzpeyhz9?a=q&qid=1

Org Chart via Google Visualization Library
https://www.quickbase.com/db/bhzpeyhzb?a=dbpage&pagename=test.html

The data was randomly generated and consisted of 100 records of [Employee] and [Manager] fields so the chart is a bit wide and shallow. And yes Google Visualization allow you to put any HTML into the boxes so you could supply additional markup and information into it including hyperlinks to drilldown reports. It only took 25 lines of code using jQuery, the QuickBase HTTP API and the Google Visualization Library.



  • Hi Dan,
    Would you know if there is a way to grant access to the user base on the Org Cchart?  
    I have a list of Employee's email address and the Manager's email address.
    I would like to grant access to the Manger base on the Org Chart.

    Thank you for your help in advance.
    Ratha
  • I have trouble using it...

    If my source table consists only from fields that are required to display chart (Employee, Manager and Role - used for mouse over tool-tip) everything works fine. But as want to have more details in source table (employees' phone numbers, email addresses, etc.) it stops working. It is enough to add one more field that is unused in chart and nothing is displayed :-( I also planned to have displayable employee information being constructed by formula-text to contain HTML formatted text composed of data coming from several fields, but this would be the next step...

    Any idea how to manage this?
  • OK, got it sorted; even if Google is not using it, you need to specify as many data columns in table as are returned by QB. E.g. Google API will not read just 3 out of 10 columns, but all of them causing data fed to org chart to be corrupted. It is necessary to define all columns in script, but Google API will use only first 3 of them.
  • Hi Dan,

    I have tried to replicate the same thing for one report where we have three columns and also mentioned all three columns in the code. But, HTML page does not show any chart when I preview it.

    Thanks,
    Gaurav
    • _anomDiebolt_'s avatar
      _anomDiebolt_
      Qrew Elite
      The demo still appears to work and you are not really giving me any information to debug what you did.
    • GauravSharma3's avatar
      GauravSharma3
      Qrew Commander
      Dan, I tried again and it worked for me. I am also drilling down to use the more features of this API. I will let you know if I need your expert advice.

      Thanks,
      Gaurav
    • GauravSharma3's avatar
      GauravSharma3
      Qrew Commander
      Hi Dan,

      I have some others fields as well. I also want to show country code and designation as well along with the name.



      Thanks,
      Gaurav
  • Hi Dan,

    Can we add another field to the box like country or job title?

    Thanks,
    Gaurav
  • Hi, Dan!

    Is it possible to add pictures or job titles

    f:'FirstName LastName<div style="color:#7dbcf1; font-style:italic; font-size:11px;">Role</div>'}
    as one of the columns?
  • MattMakris's avatar
    MattMakris
    Qrew Assistant Captain
    This works great, thanks for posting. How would you add a team name within this chart? Thanks in advance.

    ------------------------------
    Matt Makris
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      FYI, alas, Dan has not been seen on this Forum for many years.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------