I created a search box to search my secondary data source. I'm displaying my 2ds table in my form. I want hide rows if a field in my table contains the search field. However, it seems to be case sensitive when I test it. Is there a way around that?
It seems that I need to somehow get this - translate(my:field1, "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz") = translate(my:field2, "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz")
Combined with this - not(contains(d:Item, xdXDocument:get-DOM()/my:myFields/my:GearSearch))