+5Hi,
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!
Best answer by peanutbutter22
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.
+5K2 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.