Discussions

 View Only
Expand all | Collapse all

How To Create Org Charts In A Jiffy?

Eliza Eliza

Eliza Eliza06-10-2013 16:45

  • 1.  How To Create Org Charts In A Jiffy?

    Posted 04-05-2013 13:34
    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.





  • 2.  RE: How To Create Org Charts In A Jiffy?

    Posted 05-21-2013 04:07
    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


  • 3.  RE: How To Create Org Charts In A Jiffy?

    Posted 06-10-2013 16:45
    Thanks Dan!


  • 4.  RE: How To Create Org Charts In A Jiffy?

    Posted 06-09-2014 13:51
    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?


  • 5.  RE: How To Create Org Charts In A Jiffy?

    Posted 06-19-2014 08:12
    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.


  • 6.  RE: How To Create Org Charts In A Jiffy?

    Posted 05-30-2018 11:01
    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


  • 7.  RE: How To Create Org Charts In A Jiffy?

    Posted 05-30-2018 18:36
    The demo still appears to work and you are not really giving me any information to debug what you did.


  • 8.  RE: How To Create Org Charts In A Jiffy?

    Posted 06-01-2018 07:51
    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


  • 9.  RE: How To Create Org Charts In A Jiffy?

    Posted 06-06-2018 19:06
    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


  • 10.  RE: How To Create Org Charts In A Jiffy?

    Posted 06-12-2018 05:24
    Hi Dan,

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

    Thanks,
    Gaurav


  • 11.  RE: How To Create Org Charts In A Jiffy?

    Posted 08-20-2018 09:35
    Hi Dan,

    How we can add Job Title along with the name?

    Thanks,
    Gaurav Sharma


  • 12.  RE: How To Create Org Charts In A Jiffy?

    Posted 05-07-2019 10:44
    Hi Dan,

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

    Thanks,
    Gaurav


  • 13.  RE: How To Create Org Charts In A Jiffy?

    Posted 05-26-2019 18:38
    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?


  • 14.  RE: How To Create Org Charts In A Jiffy?

    Posted 09-24-2020 19:13
    This works great, thanks for posting. How would you add a team name within this chart? Thanks in advance.

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



  • 15.  RE: How To Create Org Charts In A Jiffy?

    Posted 09-24-2020 19:57
    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
    ------------------------------