always select one value in multibox setting in script or events

[#1]

Hi,

I am having two tabs in my dashboard. in one tab i need to select one value always.

when i am moving to second tab i need to clear all the fields. when i come back to first sheet i need to select one value always. If i set this value in Multibox--> Presention--> always select one value , i can't clear the values when i am moving to 2nd TAB.

Please help.

Thanks,

Suresh

[deepakk]

hi,

You need to create trigger on active sheet event.,

Right click on the sheet  --> go to trigger --> Add action -- > Selection -->Select in field --

Specify the field name and value..

you might have  to play around with =  to sign.. I dont remember if we have to add the  equal to sign or not

I hope this solves yyour problem.

Deepak

[#3]

That thing i did. it is selectting one value, but in this case i can select multiple options in the field. but i want to restrict the multi selection on the field.

[Anonymous]

Hi suresh

          We can achieve the solution for your problem using the macro .

          Hope the attached file will be helpful for your problem

Regards

Ashok