Relationship Diagrams - Need some fun now and can't wait for the June 14th release?

  • 1
  • 2
  • Question
  • Updated 3 years ago
  • Answered

If you need some fun now and can't wait for the June 14th release try appending this onto the end of your Applications Home page URL.

?a=reldiagram

as in https://mycompany.quickbase.com/db/xxxxxx?a=reldiagram

Note that the boxes will drag.

http://quickbase.intuit.com/developer/knowledge-base/quickbase-release-notes-June-14-2015

Photo of QuickBaseCoach App Dev./Training (Mark Shnier)

Posted 4 years ago

  • 1
  • 2
Photo of dwhawe

dwhawe, Champion

  • 908 Points 500 badge 2x thumb
It looks very interesting
See, I knew that you deserved some fun today.
Photo of dwhawe

dwhawe, Champion

  • 908 Points 500 badge 2x thumb
You can use VISIO with QuNect to make decent diagrams but native is typically better I think when they have the feature.
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 5,264 Points 5k badge 2x thumb
FYI - Visio 2013 no longer has Reverse Engineer - I have to boot up my old laptop which still has an older version of Visio to utilize that tool.  I ran this tool on a new application I'm building and I have to say it was great.  I had to do a lot of "fiddling" to make it look good.  I was able to "print" the page to Tabloid size PDF to make it readable.  Most importantly, it is savable!  This will make it much easier to "show" Clients how their app is laid out.  Thanks Mark for highlighting this!
Laura, when you clicked on  the big Green "Save this View", what file path did it save to?  I get a message box saying Relationship view saved.  But where did it save it to?
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 5,264 Points 5k badge 2x thumb
Couldn't figure that out either... but it does.  I expect there going to be a "link" to it some where in the Application Settings page which is currently invisible.
Photo of Keith

Keith, Champion

  • 1,192 Points 1k badge 2x thumb
I think its just a view.  So you can drag the tables around and click save.  the next time you view the diagram for that app it holds your changes.  I'm not sure we will have access to it in some file format, at least not in the first release.
Thx, now I get it!  Then for printing, it seems that the idea it to drag the boxes so they are off the area where the table names are at the top and then print the web page to a printer or a pdf "printer".
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
FWIW, the ER diagram uses the jsPlumb library:

http://www.jsplumb.org/demo/flowchart/dom.html


I think it is a big mistake to not use crow's feet instead of arrowheads on the lines indicating relationships. A valid argument can be make to have the arrow point from parent to child or vise versa so the accepted convention is to use a crow's foot on the child table to emphasize the cardinality of the relationship.
Photo of Drew

Drew

  • 522 Points 500 badge 2x thumb
I'm in the same boat with Visio.  I have an old copy on hand that I use solely for reverse engineering my QB apps.
Photo of Drew

Drew

  • 522 Points 500 badge 2x thumb
This is awesome. 

Time for a "most convoluted app" contest . . . ?
Well your app is certainly strong candidate for a winner.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
>Time for a "most convoluted app" contest . . . ?
I did a reverse google image search on the url of your E/R diagram screenshot:

https://d2iua9xsrei43a.cloudfront.net/uploads/assets/23819/original.PNG?1434066809

Google Reverse Image Search (Click Camera and Paste Above URL)
https://images.google.com/?gws_rd=ssl

Here is the link to the images Google found that are "Very Similar" to your screenshot:

Very Similar Results
https://goo.gl/lqUzL7

There are a lot of interesting results in that set but no ER diagrams!
Drew,
I see that you are in the floor covering business with Rausch.  I now understand why that app is so complicated.  I also come from a background in Floor Covering Distribution in Canada.  Floor Covering is complicated!
Photo of Drew

Drew

  • 522 Points 500 badge 2x thumb
Rausch certainly complicates things.  This app started as about a half dozen tables . . . then rapidly grew out of my control to the 80 table monstrosity it is today.  I've been in the process of splitting it up into multiple apps, utilizing more cross-app relationships, and more things in sql server via qunect to improve performance and simplify.  Everything works solid though . . .
Photo of Joey Zint

Joey Zint

  • 1,870 Points 1k badge 2x thumb
Has any consideration or development being done to allow relationship building from this view. I have been working with Power BI and this option is quite useful when linking tables together creating the one/one, many/one, etc relationships