Graphically representing relations

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 is completed :slight_smile: )

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, and then forming a URL that works with the quickchart.io api to produce the diagram.

Hope some people might find it useful :slight_smile:

UPDATE: see below for what it looks like when you open it (thanks Oshyan)

8 Likes

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.

1 Like

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

1 Like

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):

And the Fibery source table:

And an example (top-level) entity:

1 Like

Thanks @Oshyan for that. I guess I should have given people an idea of what they’d find :slight_smile:

Feel free to do the same for the Org chart :wink:

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!)

1 Like

Here’s what the org chart entities look like:

and here’s the image you get when you click the Org Chart URL for the Big boss:
image

1 Like

Really cool!

Any chance of integrating GraphViz into Fibery?

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?

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.

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.

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