Has anyone ever attempted to pass a value derived from a returned field/column on a “runtime dashboard” back to a form element on the “tracker view” portion of the same dashboard?
If so, how is this done?
The tracker view typically displays data from the selected row in the grid view.
Vinay Kamboj
Hey Bill,
You mean to display those data in Grid view, which is fits into given criteria ,set on “Tracker View” ??
Not sure exactly what you are trying to do, but if you uncheck the Prompt check box in the tracker view, it will display the selected row.
Thanks everyone.
I should have been more detailed in my original question, so I apologize for the lack of clarity.
Let’s say that I have a runtime dashboard configured to show all releases for a given vendor/supplier over a given date range. The “tracker view” allows me to filter by vendor/supplier and, of course, start and end dates.
On the dashboard grid (the panel that displays the returned records), I have a few calculated fields that determine number of releases in the list (total records returned) and a calculation of which releases were “on time” versus “late”.
What I’d like to do is an additional calculation for the percentage of “on time” releases against the total number of releases and display that percentage back to a label object on the tracker view (yes, I could use a textbox here which I’m not against, but I’d like to try putting it in a label object because I feel that it would display more aesthetically).
The general affect is, you pick a vendor for a specific date range and the tracker displays the percentage of “on time” releases for that vendor.
I may be either over-thinking, or under-thinking this.
I could do the percentage calculation in yet another calculated field, then display that value back to the tracker as a quick reference for the Supply Chain manager who views it.
I’m more hung up on “the most sensible way” to approach it… then, of course, how to actually do it.
To add to this a bit…
It seems to me that this post from March 2014 is similar to what I’m trying to do, but the answer was to publish the calculated field results to the title bar. Great option - but not exactly what I’m hoping to do.
Since the calculated result/value needs to be displayed as the text of a label object, I’d imagine that this would have to be done in the form of a customization, perhaps, using event code. Say, when the dashboard grid is refreshed with new data (the event), the calculation is performed and picked up by the event code to be inserted into the text property of the label object.
I just don’t know how to do that correctly.