Using the Searchable Multiple-Select Database attribute

You use the Searchable Multiple-Select Database attribute when you want to search and select large values at one time. A long list is defined as more than 10 values.

Procedure

To create an attribute for SMSDB, first select Multiple-Select - Database.
Then, select Searchable Multi-Select from the Attribute Type list in the Display Option section of the Custom Attribute tab.
Other settings for SMSDB remain the same as the MSDB type of attribute.
The Sort-by column is used to decide order of rendering of search results and selected values in view mode of the form tab.
After the form is created and published, and then used in a template and an instance of the template that was created, the SMSDB field is displayed in edit mode of the form.
The user interface now has a read-only select box with a Select button.
The select box display values that were previously selected in the pop-up window.

What to do next

The new SMSDB pop-up window has a text field and the Find button. When you type in the text you want to search and click Find, the result is shown in the same pop-up window in the left pane called Search Results.

The Clear button next to Find is disabled until the search is performed. When Clear is enabled and clicked, then the search text field and Search Results select box are cleared, and the Clear button is disabled until a new search is performed. The Clear button does not clear the values that are selected in Selected Values. The search term finds all occurrences of the value regardless of its position in the value and regardless of case.

You can select the values in the left bucket and move them to right bucket by using Add >>. You can click a single item or Ctrl + click for multiple separated items. Click Shift + click for a pick of sequential items. You can also use Add All >> to add all of the items at one time.

The Remove button can be used to remove items from the Selected Values list. When an item is removed, it may not make sense to return it to the Search Result list. (It may not be part of the current valid Search Results for the last search). You can also use Remove All to remove all of the Selected Values in one click.

You must click Accept and Close to save and confirm these values back in the parent form. Then, all selected values are added in the read-only select box on the parent form.

After the values are saved in the parent form, and at a later point, if you open this pop-up window again, the selected values show up in the right pane.