Defining a Pick List field
You can select an existing pick list or create a new pick list by selecting the –--New Pick List--- option. These fields are displayed:
Note:
- You can define the Network and Web Client pick list behaviours in the Pick List detail view. For example, you can select or clear the Required Entry check box for a pick list. To apply behaviours to Web Client pick lists, you must select the Apply options for the Web pick list attribute. Else, the behaviours defined by the Quick Form control that uses the pick list, is considered.
- Before setting the pick list options, ensure that you understand the Pick List control properties and how the pick list data is stored in the database. Understanding how data binds from the pick list to the database, determines if a pick list option is supported. For example, if you modify the Preferences pick list to Allow multiple selections check box, the pick list does not work properly because the database field is too small to store large text.
- Allow Multiples
- If this check box is selected, the user can select one or more values from the
list.Note: This check box is displayed as Allow multiple selections for a new pick list.
- Alpha Sort
- If this check box is selected, the items in the pick list are sorted alphabetically. If
this check box is cleared, the items are listed in definition order.Note: This check box is displayed as Sort Alphabetically for a new pick list.
- Must Exist In List
- If this check box is selected, the users must specify a value that exists in the
list.Note: This check box is displayed as Text must match a list item for a new pick list.
- None Editable
- Auto-populates the Users cannot edit items
check box on pick list definition. Sets the initial value for the Can Edit Text property of Pick List controls created
from the entity property.Note: This check box is displayed as Users cannot edit items for a new pick list.
- Value Stored As Text
- If this check box is selected, the pick list items are stored as text values.
- Name
- The name of the new pick list.Note: This field is displayed only when a new pick list is created.
- Required entry
- If this check box is selected, a value must be specified for the pick list, before a
form containing the pick list field can be saved.Note:
- This setting is defaulted for the pick list in the Form Manager. However, you can modify this default setting at the form level, in Web Form Manager.
- This field is displayed only when a new pick list is created.
You can use the Pick List Items grid to:
- Add pick list items using the icon.
- Delete pick list items using the icon.
- Add or modify the pick list item text that displays in the pick list in the Text column.
- Add or modify a pick list code value in the Code column.
- Specify the order in which the item must be displayed in the list, in the Order column.
For example, if you specify 0, the item displays as the first item in the list. If multiple
items have a same order number, the items are grouped by that number and the group is
displayed in the list, before the next highest order number.Note: If the Sorted alphabetically attribute is selected, Order values are not considered.
- Specify a value that can be used to filter picklist items in the Filter field. For example, a shared picklist in an integrated environment may contain items specific to a ERP. By specifying a Filter value, you can programmatically filter the pick list to display only items based on that value.