Currently, I'm working on spotfire comments feature.
Right now, user is able to update comments in the input box by selecting market and source value in 'property control' box.
For user friendly purpose, we hope that both market and source value can be shown in text area automatically when they select a row in datatable. Then, they just need to type in comments in input box (with out selecting svalue in property control), then comments will automatically write back to database.
With R data function, market and source value is able to show in the 'property control' box.
But I failed to connect the property control with parameter in the information link. The issue is that there is internal dependency between parameters and property control boxes.
I make it works when I create two tables and get value from another data, and send value back to current table to update comments. But performance will be really bad if data table duplicated.
Hope someone can give me a solution.