TeamDesk Knowledge Base & Support

   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” ( ) app template:


Slava Shinderov  Staff 
Date Created
7/9/2010 4:33:50 AM
Date Updated
2/2/2015 8:25:02 AM
In Development
Promoted By
Jeffrey HicksOwede, Ato (UK)Phil Gilbert
Rick CogleyPhilipp Matuschka (MMB)Liquid Rapid
Rick CogleySam ParishSlava Shinderov  Staff 
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  Staff  9/3/2010 5:49:18 AM
This feature is now available in TeamDesk Labs:
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.
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.

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

Perhaps the engine can be made to understand unicode?
Maybe not, but I thought I would mention...

Thanks again and Regards

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:
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
Back to Search Results