How can I retain the previous selection among different Buttons

[#1]

Hi QV,

In my sheet I have 4 buttons.

When I navigate from one button to another, the selections in previous button are not reflecting to current button selection.

So, my requirement is to have previous selections should not be cleared when i navigate among the buttons.

Thanks in Advance,

Ananth

[amit_saini]

Goto list box properties --> General--> Enable "Always one Selected Value" option the way I did below. This will allow one value at one time.

Thanks,

AS

[SergeyMak]

I think to avoid multiple selection you can use Calculation Condition for your charts like

GetSelectedCount(YourField_In_ListBox)=1

and add Error message for Calculation condition unfulfilled =

Please select only one YourField_In_ListBox

It could be enough    

[#4]

If I do like above, when I click on CLEAR button the selection in list box is not getting cleared. But what I need is that should be cleared when I click on Clear.

[#5]

Thanks for your response Sergey, it is somewhat helpful for me, but here the problem is, I am displaying multiple charts conditionally. If I do like as u told, then other charts get displayed(charts are overlapping based on conditions).

[SergeyMak]

But it's different options

Calculation condition on the General tab of Chart properties and Show Conditional on the Layout tab.

Unfortunately the requirements are not clear for me at the moment.

If you share the app I can try to help you.

[#7]

Thanks, but I can't share my App, it has lots of issues.

My requirement is just restrict the list box selection to only one value. User could not select multiple values at time.

[sasikanth]

HI

PFA

Attached File

[#9]

Hi Sasi, Currently i'm using personal edition, so if possible can you post the steps.

Thanks,

Ananth

[SergeyMak]

Nice idea by sasikanth_Narne

[sasikanth · Accepted solution]

Hi Ananth

For this you need use triggers

Got to Document properties , FiledEvent triggers --> Add-->Select in Filed -->

<Filed Name> , in Value box Write the condition like

"If(GetSelectedCount(Year)>1,0,  GetFieldSelections(Year)) "-->ok

Follow the Procedure ,

Thanks

Sasi