Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Graphical representation of formula, summary or lookup column calculation
When application become too complex or you are new application admin it may be time consuming to navigate through all dependent columns, tables and their relationships to find out how the value actually calculated. I believe that some kind of “Graph” can help here.

Here is the sample chart for “Total Due” column from “Invoice” table of “Invoicing” ( http://www.teamdesk.net/invoicing.html ) app template:



ID
348
Category
Setup
Author

Slava Shinderov  Staff 
Date Created
7/9/2010 4:33:50 AM
Date Updated
2/2/2015 8:25:02 AM
Status
In Development
Score
90
Promoted By
Jeffrey HicksOwede, Ato (UK)Phil Gilbert
Rick CogleyPhilipp MatuschkaNathan Phillips (CW)
Rick CogleySam ParishSlava Shinderov  Staff 
Comments
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.

Regards,
Rick
Philipp Matuschka 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  Staff  9/3/2010 5:49:18 AM
This feature is now available in TeamDesk Labs:
http://blog.teamdesk.net/2010/09/teamdesk-labs.html
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  Staff  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  Staff  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.
Nathan Phillips (CW) 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.

cht=gv:
chl=digraph{PASTEHERE}

The rendering in http://graph.gafol.net/ is better, though.
Slava Shinderov  Staff  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
Rick

Slava Shinderov  Staff  11/2/2011 12:24:35 PM
@Rick we've fixed Japanese characters problem.
Rick Cogley 11/2/2011 4:40:39 PM
Nice, thanks! Here is what it looks like now:

http://www.flickr.com/photos/81796435@N00/6307325628
Sam Parish 11/25/2011 9:40:22 PM
Wow guys this is amazing.
Slava Shinderov  Staff  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  Staff  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
Feedback
 
Back to Search Results