General

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

Imran786 — Fri, 02 Dec 2016 06:39:59 GMT

Thanks Hilary it work.

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

Hilary Stoupa — Tue, 29 Nov 2016 00:55:35 GMT

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.

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

Imran786 — Fri, 25 Nov 2016 14:39:59 GMT

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.