How To Create Org Charts In A Jiffy?

  • 42
  • 3
  • Question
  • Updated 3 weeks ago
  • Answered
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.



Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb

Posted 6 years ago

  • 42
  • 3
Photo of Ratha

Ratha

  • 0 Points
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
Photo of Eliza

Eliza

  • 60 Points
Thanks Dan!
Photo of Miroslaw

Miroslaw

  • 0 Points
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?
Photo of Miroslaw

Miroslaw

  • 0 Points
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
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb
The demo still appears to work and you are not really giving me any information to debug what you did.
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
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,

Did you get a chance to look at the above query?

Thanks,
Gaurav
Hi Dan,

How we can add Job Title along with the name?

Thanks,
Gaurav Sharma
Hi Dan,

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

Thanks,
Gaurav
Photo of Yvonne Baltazar

Yvonne Baltazar

  • 80 Points 75 badge 2x thumb
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?