General

Re: Filtering a drop-down list with conditions

jawitthoft — Thu, 23 Jul 2015 13:55:36 GMT

I'll try one more time or I might just give up. Yes, the filter on the Vendor is working fine. So this is what is in my filters. So the AC25_0016 contract shouldn't show up since it's deactivated and expired. Ughh.

Re: Filtering a drop-down list with conditions

Hilary Stoupa — Wed, 22 Jul 2015 21:05:21 GMT

Well, I mean - the filter you are using works on the Vendor drop down, right? So I can't really think of any reason why it doesn't work on the contracts dropdown. It really doesn't make sense.

Re: Filtering a drop-down list with conditions

jawitthoft — Wed, 22 Jul 2015 20:03:53 GMT

Ok, so the data is showing true or false. The Contracts in the screenshot are both showing up in the drop-down when the corresponding vendor is selected. I changed the filter to Not Equal True but no luck. Sorry to be such ignorant on this one.

Re: Filtering a drop-down list with conditions

jawitthoft — Wed, 22 Jul 2015 19:38:44 GMT

I'm just not too sharp today. I got it now!

Re: Filtering a drop-down list with conditions

Hilary Stoupa — Wed, 22 Jul 2015 19:31:17 GMT

The reason I'm suggesting this is so you know exactly what data is being returned to the form. By adding the data fields onto the form and previewing, you can see the values - but the checkbox control could be hiding something... like blank values.

Re: Filtering a drop-down list with conditions

Hilary Stoupa — Wed, 22 Jul 2015 19:28:48 GMT

I guess I'm not explaining well. Don't change your SharePoint list. Simply right click the Check Box in InfoPath and change to text. I'll post some screnshots in a minute.

Re: Filtering a drop-down list with conditions

jawitthoft — Wed, 22 Jul 2015 19:23:37 GMT

Sorry, I missed that suggestion. The Deactivated field is coming from a SP list so I'll have to update it there with a Text box. I'll let you know how it goes. Thanks!

Re: Filtering a drop-down list with conditions

Hilary Stoupa — Wed, 22 Jul 2015 19:00:02 GMT

Did you try changing that checkbox control to a text box like I suggested? So when you preview you can see the actual values?

Re: Filtering a drop-down list with conditions

jawitthoft — Wed, 22 Jul 2015 18:51:57 GMT

I feel like I'm going in circles with this silly thing. So the Deactivated field is a check box. Cleared = false, Checked = true

I tried some other combinations in the filter but no luck.

Re: Filtering a drop-down list with conditions

Hilary Stoupa — Wed, 22 Jul 2015 18:10:53 GMT

Silly form. Drag the field contracts data fields onto the form and make sure the control for Deactivated is a text box so you can see the actual value and preview - is it really false? Or maybe blank and we need to use not equal to true?

Re: Filtering a drop-down list with conditions

jawitthoft — Wed, 22 Jul 2015 17:59:56 GMT

It's showing 1 Active Contract and 1 Deactivated Contract for the Vendor.

Re: Filtering a drop-down list with conditions

Hilary Stoupa — Wed, 22 Jul 2015 16:30:59 GMT

What are the results you are getting with the filter you have added? Do any contracts show?

Re: Filtering a drop-down list with conditions

jawitthoft — Wed, 22 Jul 2015 16:26:35 GMT

As usual, I can't get it. I tried adding the filter to the Field Contracts and didn't get it right. See attached.

Re: Filtering a drop-down list with conditions

jawitthoft — Wed, 22 Jul 2015 16:20:26 GMT

That hadn't dawned on me but sounds very logical! Duh! I told you it would be something simple I was missing.

Re: Filtering a drop-down list with conditions

Hilary Stoupa — Wed, 22 Jul 2015 15:31:06 GMT

I'm confused, as usual. So - in the drop down for field vendor, where you have the filter for contract expired and deactivated, are you seeing the correct vendors? Because you then mention "the drop-down is displaying ALL the contracts" - but the drop down with the contracts is the Field Contracts, right? And the only filter on that is on vendor.... wouldn't you also need the filter for deactivated / contract expired on field contract as well?