Linking similar compnents

[Former Member]

Hello,

I thought I knew how to do this but I seem to be regressing. I would appreciate being told again.

I drive various calculations and displays from scenarios that are selected ib a list or combo box. Works fine. But because I have several pages in the dashboard, I need to give the user the ability to select scenarios on each page. So I have the same combo box on each page.

Individually, each selector works as planned. But if I select the scenario on one page and then go to the next page, although the next page displays and calcs are indeed driven by the selected scenario, the label displayed in the combo box hasn't changed, which is quite confusing for users. What I want to do is to link the combo boxes in such a way  that when a selection is made and shown on one, all of them show that selection.

All the combos point to the same destination cell and I have uncecked clear destination (and tried multiple combinations too) but it's not working.

Please let me know if you have any suggestions.

Thank you

Chris

[nikhil_joy2]

Hi Chris,

If i understood your requirement correctly, you have many combo boxes with same labels and selection in one should show  the same label automatically in others, Then make the insertion type as Label for all combo boxes and bind a particular cell as the destination. goto the behaviour tab of each combo boxes and common->selected item make it dynamic from drop down. for item map the same cell which is the destination cell for all combo boxes.

Hope it helps you.

Regards,

Nikhil Joy

[Former Member]

Hi Chris,

Link the destination of the combo box to a label based menu or Tab set.

I prefer using label based menu component , it gives user more interactivity.

Regards

Ganesh

[Former Member]

Hi Chris,

Suppose u select a page by using label based menu.In the behavior tab u have option "Insert selected Item" in common tab. Bind that option to single cell in excel sheet, let us say A1. Now for combo boxes on each page in Behavior tab u have option "Selected Item, Type", Set Type=Label and bind the Item option to A1 cell in the Excel Sheet.

So combo box gives the data based on the selected page.

Regards,

MVVK