Hey Buddy,Your as busy as a beaver but im looking forward to a video when you got time on relating data within the dashboards.
I'd love to know the trick
Thanks Thomas,
Robbie
I don't have time to do a video Robbie, but will try to explain the trick.
For this example, you couldn't use the trick. You would have to add the Keyword field to the Ranking Object and just set that within the script.
Now for the trick...
Dashboards will connect properties of the same name. Meaning two Forms with a property of the same name. Say you have two forms and each form has a Property names "Product Name". The dashboards will link those two properties.
Now comes the trick. Some Forms may have the same property but different name. So Form One has "Product Name" and Form Two has "Product Id" The data is the same between the properties but the names are different. The dashboards wouldn't link those properties together because they are named differently.
What we need to do is basically rename the "Product Id" property to "Product Name" property. We can do so by using a Calculated Field within the Dashboard (not to be confused with the ESB Calc Field... totally different).
So, to remedy that, you could add a Dashboard Calculated Field to Form Two. Right click the property and rename it to "Property Name".
Within the Calc Expression, just add the "Product Id" property.
Now you have properties with the same name to which the dashboards can link. Hopefully this makes sense. The Calculated Fields, within the dashboards, will only show up within the dashboard.
Thomas
