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

[jyothish8807]

It will clear, since i am not locking any fileds. I just forcing the user to select a product prior to Region

[PrashantSangle]

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,

[ashish_2511]

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)

[ashish_2511]

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

[jyothish8807 · Accepted solution]

Try this

I have added on trigger

[jyothish8807]

Did this worked ?

[ashish_2511]

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.

[jyothish8807]

Happy to hear it worked

Have a great weekend.