Lock/Unlock a field depending on selections in another field

[ashish_2511]

Hi Community

I've two fields in list boxes - Product and Region.

My requirement is to force users to select a product prior to selecting a region.

For this I guess I've to lock the field region when there is no selections in product and then unlock it as soon as selection(s) is made on Product and repeat.

Please advise a way to achieve this.

*** I don't want to show/hide Region based on selection in Product.

*** I don't want to Hide the Region field with a text object.

Thanks! in advance

-Sneh

[YoussefBelloum]

Hi,

1 solution comes to my mind:

Create a conditional display on the second listbox like: Getselectedcount(field1)<>0 //this will show the second listbox only if you make selection on the first one.

Also, create a textbox to show message like: SELECT A VALUE ON FIRST LISTBOX with conditional display like: Getselectedcount(field1)=0 //this will show this textbox only if you don't select a value on the first listbox

Or anoher solution would be to write this expression on the second listbox: =if(GetSelectedCount(field1)<>0,field2)

[nagaiank]

A sample solution is attached.

[shiveshsingh]

I guess, you have attached the wrong QVW

[shiveshsingh]

I think, he doesn't want this solution, no hiding of object

[ashish_2511]

Thanks for the reply.

I've already tried this. My client doesn't want this.

[jyothish8807]

Try this app:

I have used two list box for region. One in read only state.

Br,

KC

[YoussefBelloum]

nice one !

[ashish_2511]

Just a dummy dataset, no UI stuff.

but others Could use this dataset to provide their solutions.

[ashish_2511]

thanks for your reply.

I've also reached till this point but could you do some miracle to clear off the Region selection when product is cleared?