# Graphically representing relations **URL:** \ **Category:** Fibery Showcase\ **Created:** [July 30, 2021, 11:04am UTC](https://community.fibery.io/t/graphically-representing-relations/1852 "2021-07-30T11:04:36Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [July 30, 2021, 11:04am UTC](https://community.fibery.io/t/graphically-representing-relations/1852/1 "2021-07-30T11:04:36Z")
Here’s a template that demonstrates how to use Fibery to create graphical representations of the entities and their relationships (a stopgap solution until the [whiteboard functionality](https://community.fibery.io/t/tree-diagram-awol/1598/2) is completed 🙂 ) [https://shared.fibery.io/t/7c71ccad-d7e6-4a08-8cf7-0f864baeb765-network-diagram](https://shared.fibery.io/t/7c71ccad-d7e6-4a08-8cf7-0f864baeb765-network-diagram) In this example, I am modelling a bill of materials (since this is something I personally find useful) but the concept can be generalised to any set of entities/relations. Each item has a URL that, when clicked, produces a diagram of the ‘downstream’ hierarchy. It works by utilising formulas to build a description of the entity relations in the [dot language](https://en.wikipedia.org/wiki/DOT_(graph_description_language)), and then forming a URL that works with the [quickchart.io api](https://quickchart.io/documentation/graphviz-api/) to produce the diagram. Hope some people might find it useful 🙂 UPDATE: see [below](https://community.fibery.io/t/graphically-representing-relations/1852/4) for what it looks like when you open it (thanks Oshyan) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [July 30, 2021, 11:22am UTC](https://community.fibery.io/t/graphically-representing-relations/1852/2 "2021-07-30T11:22:45Z")
~~By the way, for the item names I had to substitute spaces with underscores in the diagram, since I couldn’t figure out how to create a text string containing "~~ UPDATE: I’ve fixed this by using `%22` instead of `"` which is fine for the URL API. The app templates are now updated. Still, it would be nice if this issue could be fixed more generally. > [@Escape characters](https://community.fibery.io/t/escape-characters/1685): > > Does anyone know how to use escape code characters in text fields or formulas? I want, for example, to be able to add tabs, carriage returns etc. If it’s not possible, I’ll change this to a feature request slight_smile [update: no reply, so moved to feature request category slight_smile] ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [July 30, 2021, 11:34am UTC](https://community.fibery.io/t/graphically-representing-relations/1852/3 "2021-07-30T11:34:26Z")
And here’s a simple Org chart version of the same idea, since I get the impression that this might be popular: [https://shared.fibery.io/sign-up?appShareId=38b924ce-449e-4537-be66-5f955d18ab98-org-chart](https://shared.fibery.io/sign-up?appShareId=38b924ce-449e-4537-be66-5f955d18ab98-org-chart) ---
**Author:** ![Oshyan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/oshyan/32/11431_2.png) [@Oshyan](https://community.fibery.io/u/Oshyan)\ **Post date:** [July 30, 2021, 10:49pm UTC](https://community.fibery.io/t/graphically-representing-relations/1852/4 "2021-07-30T22:49:59Z")
Cool! I added it to my workspace just to see exactly how it looked/worked. For those who just want a quick visual, here is the outcome (SVG): ![graphviz](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/7/73f44bbea63a787e5017babb3697bb40d9c2dc04.png) And the Fibery source table: ![graphviz-source-table-fibery](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/d/da085aee3a7da254db109e7fe644ba898b937e8c.png) And an example (top-level) entity: ![graphviz-entity-view-sample-fibery](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/97a28b884a6360948d7307c8650be71339c67f4d.png) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [July 30, 2021, 11:02pm UTC](https://community.fibery.io/t/graphically-representing-relations/1852/5 "2021-07-30T23:02:19Z")
Thanks @Oshyan for that. I guess I should have given people an idea of what they’d find 🙂 ~~Feel free to do the same for the Org chart 😉~~ To be honest, the `1x Product` Instance showing in your third image is actually redundant, unless `Product` were to become incorporated into another level above, so I’ve removed it. (I actually created it when experimenting with circular relations but that’s another story!) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [July 31, 2021, 11:09am UTC](https://community.fibery.io/t/graphically-representing-relations/1852/6 "2021-07-31T11:09:36Z")
Here’s what the org chart entities look like: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/33b36f80a9cdade51a9cde9570e9b4d8de3dd6ea.png) and here’s the image you get when you click the Org Chart URL for the `Big boss`: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/d/dd5e8b895f9a6df7bac4d708597645d089383771.png) ---
**Author:** ![Mikkling](https://avatars.discourse-cdn.com/v4/letter/m/d78d45/32.png) [@Mikkling](https://community.fibery.io/u/Mikkling)\ **Post date:** [February 12, 2022, 1:47pm UTC](https://community.fibery.io/t/graphically-representing-relations/1852/7 "2022-02-12T13:47:26Z")
Really cool! Any chance of integrating GraphViz into Fibery? ---
**Author:** ![cannibalflea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cannibalflea/32/318_2.png) [@cannibalflea](https://community.fibery.io/u/cannibalflea)\ **Post date:** [February 23, 2022, 8:46pm UTC](https://community.fibery.io/t/graphically-representing-relations/1852/8 "2022-02-23T20:46:26Z")
This very cool indeed. I have a use case where I would definitely try it. I was actually wondering if anyone has used any other tools to graphically visualize the relations in their data. Has anyone been able to use a tool like gephi or yEd to easily accomplish this? ---
**Author:** ![uniquelau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/uniquelau/32/3836_2.png) [@uniquelau](https://community.fibery.io/u/uniquelau)\ **Post date:** [February 24, 2022, 8:52am UTC](https://community.fibery.io/t/graphically-representing-relations/1852/9 "2022-02-24T08:52:57Z")
Very cool, would love to use something like this to represent the permissions model within Fibery, as I’m forever forgetting who has access to what. ---
**Author:** ![lpartan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/lpartan/32/137_2.png) [@lpartan](https://community.fibery.io/u/lpartan)\ **Post date:** [March 1, 2022, 4:42am UTC](https://community.fibery.io/t/graphically-representing-relations/1852/10 "2022-03-01T04:42:47Z")
Heads Up, Chris. I have twice added the Space that should be, by all appearances, Org Chart (…1050b-org-chart). But it is instead titled Dependency Drop down having Categories, Vehicles, Drivers. The BOM Space is good. thx. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [March 1, 2022, 7:15am UTC](https://community.fibery.io/t/graphically-representing-relations/1852/11 "2022-03-01T07:15:42Z")
Sorry about that. I must have updated the space to use for other purposes. I have managed to restore something that I think matches the original. Hope it works now. ! [Org chart — Fibery](https://shared.fibery.io/sign-up?appShareId=38b924ce-449e-4537-be66-5f955d18ab98-org-chart)