Re: Filter Values before binding to a dropdown.

Anson Hidajat — Thu, 18 Oct 2012 19:34:34 GMT

Filtering the dropdown when it appears more than 4 times is a little trickier than your traditional filter rule. Maybe what you can do is create a secondary repeating field that you can add entries to when the count for that value is 4 or more. Then you can apply this field to your filter. If you know there are x number of options and if x is reasonably small you can create multiple dropdowns and hide them accordingly. Those are just a few ideas I had of how you can implement this. Maybe someone else out there has a more elegant approach :)

Filter Values before binding to a dropdown.

yogesh_nt — Thu, 18 Oct 2012 06:17:31 GMT

Hi,

I have a master list Test1 which has values

and use this column as a lookup in another list Test2. I have customised the Test2 list form using InfoPath 2010.

I want to restrict (read as)[filter the value out before binding the values to the dropdown using a data connection] the users to select the values, based on a condition that the value{A,B,C} exists in the Test2 for more than 4 times. So that no user can select the value A if it exists more then 4 times. The option A has to be filtered out and not be displayed in the dropdown.

Can we filter out this way ?

Thanks in anticipation.