Hello everyone.
I am building a request form that will go to multiple approvers.
In the initial request, I have 3 drop down boxes that are linking to the same data source.
Is there a way to either limit or not allow a requestor to select the same item in each drop down? (attachment)
I have tried different advanced conditions using data label versions of each field, but i am not having any luck.
This may be one possible implementation, but some things to consider are:
- when mapping a data source to a drop-down control, usually it will map value = ID, and Display may be something else; if dragging and dropping the control, the control will return the value/ID and not the display (this is why the example above filters by ID)
- Added a 'when control is changed 'event, to affect the result of the next control, used a populate list control with a filter, where ID not equal to the ID selected from the previous control
- third control will return IDs not selected in the first and second control
- perhaps consider making the control Read-Only to start with, then enabling the control when the preceding control is selected; this way the order in which the control can be selected is controlled
I think your on to something. I will work on this and get back to you.
Thank you :)
Got it working beautifully!
Thank you :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.