I am looking to create an organizational chart from my excel spreadsheet within the app. In the first column i have the employee, the second column has the employee in which they directly report, and the third column has if they are a full time or temp employee.
My goal is to create an interactive org chart in the app that you can edit via original excel source data as well as have formatting rules for FT/Temp employees.
Is this possible?
Hi Matt,
I donโt believe we have a visualization type which is well suited to displaying a branching organizational chart as of yet.
It would be possible to capture the data and view it as a linear/tiered hierarchy in a simple table or deck though. You could also build a view which centers on individuals and shows their upward and downward reports, but I canโt think of a good solution for node hierarchy visualization for more than one node at a time.
Hereโs an earlier thread exploring the same issue you are experiencing, doesnโt look like anyone arrived at a clean solution for building a visual org chart Hierarchy Views
Any ideas, clever forum lurkers?
If you send me your email at hayden@appsheet.com I can add you as a coauthor to an app which demonstrates how to set up a hierarchy data structure, minus the tree visualization piece.
Iโd love to see what you came up with.
Feel free to shoot me an email and I will send it your way as well! I cannot take credit for this solution however, one of our SAs created it.
Hey Hayden!
This is my email. Thanks for thr help!
Hey Matt - looks like something went awry in pasting your email.
Hmm let me try again
Added!
Hi Hayen, can you add me as well siriuslea at hotmail.com?
Yep, thatโs pretty much the only โrealโ approach. And, itโs what we currently do. Basically crawling the detail viewsโฆ Iโve seen some crazy trickery with dashboards and virtual columns, but it was pretty dang messy.
Please do you mind if I get added?
Hi, can I also request to be a co-author of this app? my email address is: ecgaspar@globe.com.ph. Thanks.
Hi Hayden Can I be added to ? My email is renee.espinoza@ecnautomation.com
I should have done this back in December - but Iโve made this a public sample app: https://www.appsheet.com/newshortcut/f5fcf58f-b3ff-40f7-ab2e-65600eb92fea
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |