Create an Org Chart

[mfreund21]

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?

[Hayden]

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?

[Hayden]

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.

[Grant_Stead]

I’d love to see what you came up with.

[Hayden]

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.

[mfreund21]

Hey Hayden!

This is my email. Thanks for thr help!

• Matt

[Hayden]

Hey Matt - looks like something went awry in pasting your email.

[mfreund21]

Hmm let me try again

Freundmp@gmail.com

[Hayden]

Added!

[siriuslea]

Hi Hayen, can you add me as well siriuslea at hotmail.com?

[Grant_Stead]

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.

[Laurene_Haynesw]

Please do you mind if I get added?

[ecgaspar]

Hi, can I also request to be a co-author of this app? my email address is: ecgaspar@globe.com.ph. Thanks.

[Ree]

Hi Hayden Can I be added to ? My email is renee.espinoza@ecnautomation.com

[Hayden]

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