I have an XML file (or CSV) being used to populate a dynamic navigation menu. I would like to dynamically update the buttons in the navigation menu with the value of the corresponding point in the hierarchy tree.
The dynamic navigation menu works like a charm using the XML data widget combined with the amazing filtering & query abilities. Now second step, I would like to have the toggle buttons in the dynamic navigation menu to be updated with the latest value. The XML file contains for every button, the name of the datapoint but I do succeed in adding a colum with a formula or binding to obtain its latest value.
How can I do this?
PS. Going to a SQL database is unfortunately not an option since this implicates big changes as proposed in other topics.
Thanks for giving me the missing piece ;-)