Newbie Questions

Re: Hide previously selected values

murphythadog — Mon, 23 Mar 2009 13:18:10 GMT

Can I filter based on what is displayed instead of the value? If I change the value to Department then my field3 does not show the correct value which would be the Total Gross area of the department.

Re: Hide previously selected values

Anuma — Mon, 23 Mar 2009 05:54:38 GMT

Hi,

Can you change "Value" in the Department Dropdown Propeties to "Department. Then below filtering will work for you.

not(my:Department = current()/preceding-sibling::my:group2/my:field2)
not(my:Department = current()/following-sibling::my:group2/my:field2)

Verify attached xsn for better idea.

Re: Hide previously selected values

murphythadog — Fri, 20 Mar 2009 13:27:04 GMT

That works perfectly. I'm trying to accomplish that in the field2 drop down as well. So far i've tried:

not(my:field2 = current()/preceding-sibling::my:TOC/my:TOCgroup/my:group2/my:field2)
not(my:field2 = current()/following-sibling::my:TOC/my:TOCgroup/my:group2/my:field2)

not(my:Department = current()/preceding-sibling::my:Department)
not(my:Department = current()/following-sibling::my:Department)

I'm wondering if this one is possible since i have the value set as my:TotalGrossDepartmentArea/my:Total and the display set as my:Department if this one will actually filter correctly. Any ideas.

Re: Hide previously selected values

Anuma — Fri, 20 Mar 2009 06:01:02 GMT

Hi,

I have added filtering for "SectionTitle" dropdown in the attached xsn.

Re: Hide previously selected values

murphythadog — Thu, 19 Mar 2009 20:14:50 GMT

Here is the link to the xsn. I have a filter that i've since removed on there, in case your wondering where it came from.

http://www.infopathdev.com/forums/storage/39/38635/HealthCare_Space_Program_Version2.xsn

Re: Hide previously selected values

Anuma — Thu, 19 Mar 2009 06:07:38 GMT

Hi,

Can you verify attached xsn for this. And let me know still you have any issues with this.

Otherwise give me your schema or xsn. So that i will give exact solution for your issue.

Re: Hide previously selected values

murphythadog — Wed, 18 Mar 2009 13:04:31 GMT

This is the image of the drop down box.

Re: Hide previously selected values

murphythadog — Wed, 18 Mar 2009 13:03:44 GMT

I believe that is the right direction but I can't seem to get it to work. I'm not sure if I'm filtering on the correct data since all the previously selected Departments still show up.

Re: Hide previously selected values

Anuma — Wed, 18 Mar 2009 06:50:24 GMT

Hi,

Can you verify "FILTERING LISTS FOR UNIQUE VALUES" steps in the below link.

http://www.infopathdev.com/blogs/greg/archive/2005/07/14/Create-a-Repeating-Cascading-List-from-a-Flat-Data-Source.aspx

Hide previously selected values

murphythadog — Mon, 16 Mar 2009 20:40:44 GMT

How do force infopath drop down list box not to show previously selected items? My drop down list can get quite long, sometimes it's hard for the user to determine if they've picked an item before. I've seen posts on how to fix this but it doesn't seem to work for me.