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
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)