Entering multiple selections in a list box

[#1]

Hi everyone,

Here’s my scenario:

• I have a list box that has the identification number for our partners.
• I have a user that wants to select about 12 of these partners without scrolling through the list and holding down the Control
  key and selecting each one.

My question:  How do I allow the user to type in the identification numbers for all 12 of the partners they want to see information for?

I’ve tried using the Match() function in the Advanced Search of the list box, but that is not a viable solution for a user.

Any suggestions would be appreciated.

Thanks!

Scott

[cjohnson · Accepted solution]

Hi Scott,

Try the following format when searching in the list box:

(search1|search2|search3)

Example:

Remember to remove the wildcards (*) if they exist.

If you type this in a search it should work.

Thanks,

Camile

[vikasmahajan]

check with this thread Missing Manual - GetFieldSelections() + Bonus Example

Vikas

[#4]

Use  a Select -> Select in Field button action.

Type in your field name and as search string whatever you want to select for example: (selection1|Selection2) the search string needs the ()

[#5]

Thanks, Camile!  That worked! 

I also discovered a couple things regarding selecting from a list box that I thought I’d pass on.

Suppose you want to select 2 customers from the List Box for “Company Name”

When you want to search for a string with >1 word like, “A Company’s Name”, you should enclose the entire string in
double quotes:

     Ex. (“A Company’s Name”|”Another Company’s Name”)

If however, you don’t know the full string you’re searching for, you can use wildcards:

     Ex. (“A Company’s *”|”Another Company’s *”)

Hope this helps others.

Thanks again!

Scott