Solved

Filter a picker

  • 10 October 2017
  • 1 reply
  • 5 views

Badge +5

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

icon

Best answer by peanutbutter22 11 October 2017, 12:52

View original

1 reply

Badge +5

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