Hey guys,
I have a dropdown in my form that is fed from a SP list and contains several hundred records. What I would like to do is allow the user to select a filter: A-I, J-R, S-Z, and 0-9 and have the value of that selection be an expression that can be used to filter the main dropdown. Is it possible to set the filter to something like "begins with @Filter" where @Filter would be a value such as ([A-Ia-i])?
I can't figure out the correct syntax for this expression if it is possible and would appreciate some help.