How to filter drop down list box based upon another Field ? - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

How to filter drop down list box based upon another Field ?

Last post 12-01-2016 10:39 PM by Imran786. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 11-25-2016 06:39 AM

    How to filter drop down list box based upon another Field ?

    In my form i add drop down list box i bind the list to this drop down list in this list contains large no of data so i want to filter the drop down. So i add one text box before the drop down. I want to filter the drop down value based on text box enter text it work but issue is that If i enter Xyz then drop filter show only Xyz filter result but not showing the xyz. I means case sensitive issue. I filter the drop using the contains filter to check is textbox value is in drop down.
  • 11-28-2016 04:55 PM In reply to

    Re: How to filter drop down list box based upon another Field ?

     Unfortunately, the only way around case sensitivity is to use the translate function in your filter - so you'd compare translate(field1, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz') to the other field - and translate that as well.

    Hilary Stoupa

  • 12-01-2016 10:39 PM In reply to

    Re: How to filter drop down list box based upon another Field ?

    Thanks Hilary it work.
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.