Selector/Multiselector Field Type
Copyright © 2019 EarthSoft, Inc • Modified: 31 May 2019
Fields with a selector data type (Selector, MultiSelector, Group Selector, Group MultiSelector) have the following additional options that can be set when editing the field.
Display Mode – Two options are available:
•List – Show all items in one column; ideal for very long lists of options.
•Buttons – Several items per row in button.
Display Format – Show the Code, Description, or some combination of them in the selection buttons displayed to the user.
Option Delimiter – Used for MultiSelector or Group MultiSelector. Sets the character used to separate each of the options chosen by the user (e.g., a comma). Check the Space box to use a space as the separator.
The Options Tab establishes the members of the static list of items from which the user will select. The options list can be created by manually entering the options, importing a reference table, or importing a Microsoft Excel file.
Type a value in the New Option text box and, if desired, an accompanying description in the New Description box. Press Enter on the keyboard or click the Add button to add the item to the Options list.
This method enables the import of values directly from a reference table in EQuIS. Note that the Options imported are still static entries; they will not automatically update if changes are made to the source reference table.
Select the Import Reference Table button to open the Reference Table Import window. Click in the Table box to load the list of available reference tables. The Search box can be used to filter the list of tables to easily find the desired table. Select the desired reference table.
Identify which columns from the loaded reference table will supply the Code and Description fields. These are required fields. If needed, use the filter bar to filter the rows displayed. Check the box next to each item to be imported. Clicking the check box in the upper-left corner of the table will select all visible rows. Click the Import button.
A Microsoft Excel file can be used to bulk import options. The Excel file should have the following structure on a worksheet:
•In column A, supply values that will be the Code for each option.
•(Optional) In column B, supply values that will be the Description for each option.
To import the options, click the Import Excel button and open the Excel file when prompted. Select which worksheet to import. For single Selector fields, only one worksheet can be selected. For MultiSelector fields, multiple work sheets can be selected.
For Group Selector or Group MultiSelector fields, the Excel file can be organized to supply options in groups. Create a worksheet in the Excel file, configured as explained above, for each desired group of options. The title of each worksheet in Excel will become the title of the resulting option group.