Skip to main content
Question

How To Create Org Charts In A Jiffy?

  • April 5, 2013
  • 0 replies
  • 125 views

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.



This topic has been closed for replies.

  • Registered
  • May 21, 2013
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

  • Registered
  • June 10, 2013
Thanks Dan!

  • Registered
  • June 9, 2014
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?

  • Registered
  • June 19, 2014
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

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
Forum|alt.badge.img+7
  • Registered
  • September 24, 2020
This works great, thanks for posting. How would you add a team name within this chart? Thanks in advance.

------------------------------
Matt Makris
------------------------------