Re: Filter data in control drop-down

Reema Daga — Wed, 20 May 2015 18:22:26 GMT

Hi there,

How about you set a filter on the second drop-down(Field Contracts) to only filter Field Contracts that are not Deactivated.

Steps to add a filter on the Field Contracts drop down:

1) Select Fields Contracts drop down->Right Click->Select Drop-down List Box Properties

2) Click on the xPath for Entries

3) Click->Filter Data->Add

4) Select Deactivated is equal to TRUE

Please see the attached screen shot.

Hope this helps!

Kind Regards,

Reema Daga
Qdabra® Software / InfoPathDev.com / FormsQuo / 425 999 4597 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Filter data in control drop-down

jawitthoft — Mon, 18 May 2015 16:22:36 GMT

Hi - I have a from with 2 drop-downs that is filtered based on the selection of the first drop-down and data in my SP list. I want to further filter the data based on a Boolean field in the SP list. I can't figure out the logic to filter it based on a second criteria.

The first drop-down (Field Code) sets the values of the second drop-down (Field Contracts) but I only want to see the Field Contracts that are not Deactivated based on the Boolean field in the SP list.

Any ideas on how to add a second filter to a drop-down? I tried adding it to the Field Code and Field Contracts field but it didn't work so I'm sure I'm not getting the syntax or order of operations correct.

Thanks in advance for your time.

Controls

Re: Filter data in control drop-down

Filter data in control drop-down