Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It will clear, since i am not locking any fileds. I just forcing the user to select a product prior to Region
Try below
1: create list box with expression as
aggr(product,product)
or
2: List box with product
go to property > general > hide excluded
This way you will show only data from Product which related to selected region only
Regards,
This fulfills just part of my requirement.
when you select a product and then a region and then deselect product, the selection in Region stays (both list boxes Read-only checked or unchecked)
Thanks! but this this doesn't serve my purpose.
As I've mentioned above -
when you select a product and then a region and then deselect product, the selection in Region stays
Try this
I have added on trigger
Did this worked ?
Yes this worked Thanks!
I'd totally disregarded the on any select trigger. I was just trying to make it work with field event triggers.
Happy to hear it worked
Have a great weekend.