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 as buttons.
Display Format – Show the Code, Description, or some combination of them in the selection list or buttons displayed to the user in Collect Mobile on their device.
Code Delimiter – Used when selecting a combination of Code and Description for the Display Format option. Sets a character used to separate the Code and Description values (e.g., a dash). Check the Space box to use a space as the separator.
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 hyphen, comma). Check the Space box to use a space as the separator.
The Options Tab establishes the items in the static list from which the user will select. Selector items are defined by a "Code" and/or a "Description". By default, the description will be used if nothing is selected. If a description is not available, the code value will be displayed in the selector list on the mobile device. The code must be a unique value. If entering the same code value more than once, the existing code and associated description (if present) will be overwritten with the new code and description.
Note: When creating formulas using fields with any selector fields types, the formula output will reference the code value not the description.
The selector list items or buttons can be ordered by either the code or description values. To define the display order, select either Code or Description from the Sort Column drop-down and then click the By Order drop-down to choose from ascending or descending alphabetical or by length.
The selector options list can be created by: (1) Manually entering the options, (2) Importing a reference table, or (3) Importing a Microsoft Excel file.
Type a code value in the New Option text box and 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 selector list items 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 selector list items. The Excel file should have the following structure on a worksheet:
•In column A, supply values that will be the Code for each list item.
•(Optional) In column B, supply values that will be the Description for each list item.
To import the list items, 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.
Copyright © 2021 EarthSoft, Inc • Modified: 11 Aug 2021