ORGANIZATION CHART

[chiukim]

I'd like to create an organization chart using appsheet set up. Example he/she will manually add new employee then tag his/her position in the organization. Then, using scheduled bot it will show the hierarchy chart. I looked on UX option but it seems no options for organizational chart. so i think automation is the last resort here. Then, using scheduled bot it will show the hierarchy chart

Please help if this is possible?

[Suvrutt_Gurjar · Accepted solution]

You could possibly use charts option available with Google sheets and embed that chart as an image in your app.

Organizational charts - Google Docs Editors Help

Since org charts typically are not required to  update instantly some lag in update should be acceptable.

I had also shared a tip on creating hierarchy charts but their structure is different and implementation is a bit tricky.

Create hierarchy views using table views - Google Cloud Community

[Suvrutt_Gurjar · Accepted solution]

You could possibly use charts option available with Google sheets and embed that chart as an image in your app.

Organizational charts - Google Docs Editors Help

Since org charts typically are not required to  update instantly some lag in update should be acceptable.

I had also shared a tip on creating hierarchy charts but their structure is different and implementation is a bit tricky.

Create hierarchy views using table views - Google Cloud Community

[chiukim]

Thanks for the response. Ive tried it with the google sheets. But it so simple. I need to add same data like the name and other numerical values.  

[chiukim]

Thanks for your sharing another ways. i will try it if my boss will like the design. 

[chiukim]

Hello. Do you have links/guide on how can i copy the image in my google sheet to my app?

[Suvrutt_Gurjar]

Please follow this Tip and Trick post by @Koichi_Tsuji 

Please follow the entire thread. Google sheet charts do not update automatically. You may need to wait 30 minutes for auto sync by the AppSheet app or use the approach suggested by @hru to open the chart in browser in the same post.

Place the Google Sheet Chart onto Appsheet app - Google Cloud Community

[chiukim]

Thank you. Can you help me why this is happening? 

[Suvrutt_Gurjar · Accepted solution]

The following is not tested and the question is really about using the Google sheet charts but please test by removing the highlighted row in yellow. 

If you still want to enter the details of the managing director in a separate row, then create a slice excluding that row and please make your chart based on that slice.

[chiukim]

thanks a lot!