Multi select from List Box

[jduenyas]

Hi all

I have a list of many zip codes which I need to select from a List Box containing all of US zip codes.

Aside of clicking each value while holding the CTRL key, is there a way to enter (using key board or pasting a list) into the search line for the list box to select multiple items? Is there a delimiter that the list box recognizes when keying the different values?

Thanks

Josh

[#2 · Accepted solution]

Ive used advanced search using expressions to do something similar to this.

Right click in the list box and goto advanced search.  in the expression, put something like

=MATCH([FIELD NAME GOES HERE],'ZipCode1','ZipCode2','ZipCode3',...etc)

Then press GO. Make sure to copy your formula before pressing GO if you want to re use it.  If the list is long, I use Excel to generate the list in the proper syntax and paste it into the expression.

EDIT - Actually, i just tested and you can type this formula directly into the search line and it will also work

[jduenyas]

Wonderful!

That worked.

Thank you