Frédérik_Dussault 7/9/2010 7:29:29 AM
This is interesting indeed !!
This would be a major improvment. If you go for that, visualize how this would be required by users for other part of your application - such has Table relations, Actions and Rules...
Rick Cogley 7/11/2010 3:02:46 AM
Yes, absolutely. This sort of thing, looking into the application's "metadata" and so on, would be very helpful. Producing documentation like this is often required for client projects, but if the system produces this kind of graphic for you, it really helps with that.
Philipp Matuschka (MMB) 7/29/2010 6:26:02 PM
This is good. While you are at it, how about a graphical representation of the complete entity relationship diagram
Slava Shinderov 9/3/2010 5:49:18 AM
Rick Cogley 9/3/2010 6:38:23 AM
Fantastic! Works like a charm.
I want a way to automatically paste that dot code into gafol's (or some other) site via POST!
Rick Cogley 9/3/2010 6:44:22 AM
Some columns have the Dump and some do not. What governs it?
Kirill Bondar 9/3/2010 6:50:39 AM
Only lookups, summaries and formulas can be dumped. Other columns have no rich network of dependencies.
Rick Cogley 9/3/2010 7:16:56 AM
Ah, ok - got it Kirill. Thanks
Frédérik_Dussault 9/3/2010 9:33:38 AM
I have enable the "Graphical representation of formula, summary or lookup column calculation" feature under "Available Labs".
I have looked at all Column Setting pages but alas, haven't found the Dump button...
Did I missed a step?
Kirill Bondar 9/3/2010 10:05:57 AM
@Frédérik: Dump button is available when *viewing* column properties - click on a link with column name from the column list.
Liquid Rapid 9/6/2010 2:45:47 PM
This is really great. It shows the columns exactly the way I think about them. And it's really nice that it shows the relations calculations right in the graph. Nicely done.
Rick Cogley 9/21/2010 5:40:00 PM
Just thinking about how this might be useful in a real-world documentation scenario. It would be good if we could get a list of all the items in the db that had this dump capability, or, if we could get a big graphviz file that represents all the dumpable objects, so that could be printed all at once.
By the way, it looks like you have to do something special to make graphviz work with unicode in object names, because it comes out wrong when I paste code with Japanese into those graphviz viewers. I bet you have to load certain libraries to make it work...
Rick Cogley 9/25/2010 5:46:55 AM
It is somewhat possible to use the GraphViz option of Google's Chart Playground to render this code. http://code.google.com/apis/chart/docs/chart_playground.html
If you strip the carriage returns out of the code that comes out of the Dump button, and paste it within the parameter language Google understands, it renders if imperfectly.
The rendering in http://graph.gafol.net/
is better, though.
Slava Shinderov 11/2/2011 8:20:02 AM
We've improved "Dump" button functionality, now it displays graph image in place, so you don't need to copy/paste description anymore.
Rick Cogley 11/2/2011 8:51:39 AM
Slava, that is fantastic, thanks!
Feedback: I am getting little boxes where there probably should be Japanese characters, FYI: http://www.flickr.com/photos/81796435@N00/6305544115
Perhaps the engine can be made to understand unicode?
Maybe not, but I thought I would mention...
Thanks again and Regards
Slava Shinderov 11/2/2011 12:24:35 PM
@Rick we've fixed Japanese characters problem.
Rick Cogley 11/2/2011 4:40:39 PM
Sam Parish 11/25/2011 9:40:22 PM
Wow guys this is amazing.
Slava Shinderov 12/15/2011 7:56:00 AM
We've added column dependencies graph.
It allow you to visualize dependent dropdown columns and columns affected by dynamic calculations.
You can find new "Dump" button on Columns -> "Customize existing columns" screen.
Slava Shinderov 12/17/2011 12:58:29 PM
We've added workflow rules graph.
You can find new "Dump" button on Rules -> "Workflow Rules" screen.
Owede, Ato (UK) 2/2/2015 8:25:02 AM
Beofr ejoining TeamDesk, this is a feature that would be very useful for us as a company and for individual employees to understand dependencies across all the systems