Skip to main content

Hi,

 

I am trying to filter the values returned in a picker based on the value of another picker - however I can't seem to get it to work. The two pickers are on different views so I am trying to complete the filter on form level. Does anyone have any idea on how this can be done? See attached screenshots. I want the values in Picker 2 to be filtered by the client in Picker 1.

 

Thanks!


15138i7DD7E3413C68310E.jpg
11134i6EDED94039EEA826.jpg

K2 were able to provide a solution to this.

 

As you mentioned, the pickers on different views so you will need to configure a rule on the form level to transfer the value of the first picker to the view that has the second picker, the rule would be

When Picker1 is changed
Transfer data(transfer the first picker value to a datalabel/parameter in the second view)

You will need to pass the value of the first picker as input mapping in the resolve rule of the second picker or you can configure the data source of the picker then configure the method (attached), then drag the control that contains the first picker value to the required field to filter the results.


Reply