I have created a dashboard using a custom BAQ that contains the Summary Grid and a Tracker View. I would like to use the data from the custom BAQ in the Summary Grid to do a lookup using the script editor in the Tracker View. Then compile the data from the lookup with the data from the Summary Grid and display the combined data in the Summary Grid.
Here is an outline:
1) Within the script editor of the Tracker View,(Before the Summary Grid gets loaded) grab a reference to the Summary Grid.
2) Loop through the data in the Summary Grid and perform a lookup to obtain additional data.
3) Combine the original data in the Summary Grid with the additional data.
4) Display this combined data in the Summary Grid.
I guess my main question is, how do I gain a reference to the Summary Grid and the data view in the script editor of the Tracker View?
- Scott
Here is an outline:
1) Within the script editor of the Tracker View,(Before the Summary Grid gets loaded) grab a reference to the Summary Grid.
2) Loop through the data in the Summary Grid and perform a lookup to obtain additional data.
3) Combine the original data in the Summary Grid with the additional data.
4) Display this combined data in the Summary Grid.
I guess my main question is, how do I gain a reference to the Summary Grid and the data view in the script editor of the Tracker View?
- Scott