Example: Adding a new pick list to a form

Use the Add Field or Edit Field view to add a new field or modify an existing field.

Note: The system administrator and users with the appropriate role can access these features. See What are Roles and Secured Actions?
  1. Select Entity Manager from the navigation bar.
  2. Select the entity of the field you require to add from the Entity Manager list.
  3. Select the Fields tab in the lower pane and click Add if required.
  4. Specify the field name you require to be displayed in the application Web Client in the Display field.
  5. Specify a unique and descriptive name for the field in the Name field.
  6. Select Pick List in the Type field.
  7. Complete the remaining information:
    Length
    Specify the maximum length for the field.
    Storage
    Select a data storage method.
    Display
    Select a method in which data displays in the Web Client.
    PickList
    Select - - - New Pick List - - -.
    Value Stored As Text
    If selected the pick list items are stored as text values.
    Name
    Specify a name for the new pick list
    Allow multiple selections
    If selected, allows the users to select one or more values from the list.
    Text must match a list item
    If selected, users cannot type in a value that does not already exist in the list.
    Required entry

    If selected, the pick list must contain a value before a form containing the pick list field can be saved.

    This sets the default value of the required option for the pick list in the Form Manager, but the form manager can be edited at the form level in Web Form Manager.

    Sorted alphabetically
    If selected items in the pick list are ordered alphabetically. If cleared, items are listed in definition order.
    Users cannot edit items
    Sets the initial value for the Can Edit Text property of PickList controls created from the entity property.
  8. Add items to the pick list:
    1. Click Add above the grid.
    2. Click the Text column to add the pick list item text which displays in the pick list.
    3. Click the Code column to add a pick list code value.
    4. Click the Order column to specify the order the item must display in the list.
      For example, if you specify 0, the item displays as the first item in the list. If you have multiple items with the same order number, they are grouped by that number and the entire group displays in the list before the next highest order number. Note that if the Sorted alphabetically attribute is selected, Order values are ignored.
    5. Select the pick list item which must be the default value of the pick list in the Is Default column. Only one pick list item can be the default.
    6. Specify the value of the filtering pick list that must be selected in order for the pick list item to be available in the list in the Filter field.

      For example, for the pick list item to be displayed when the account status is equal to Purge, specify Purge.

      Note: 
      • In order to filter correctly, this value must match a corresponding item in the filtering pick list .
      • A pick list can be used for more than one field. The pick list is filtered by this value when the field using this pick list has a Pick List filter data binding defined. See the Application Architect Help topic "Filtering a Pick List" for detailed steps.
    7. Repeat steps 6a-6f for each pick list item to add to the pick list.
    8. Click OK.
  9. Select any of the following settings:
    Is Key
    Indicates if the selected field is a primary key for the entity.
    Audited
    Indicates if the changes are being tracked for the field.
    Can Bulk Update
    Indicates if the field can be updated as part of a bulk action.
    Import
    Indicates if the field can be imported.
    Match
    Indicates if the field is match criteria for an import.
  10. Click OK.
  11. To access the Form Manager list View, select Administration from the Navigation Bar and click Form Manager. A list of quick forms are displayed. See Quick forms
  12. Select the form to be added to the pick list field.
  13. Find the new pick list control and drag the pick list to the form on the Web Form Manager, in the Add field. See Form designer - working with forms
  14. Drop it on any location that is highlighted in green when the cursor hovers over it.
    The control is created and bound to the data field in the database.
  15. Use the tabs to set the control properties with the pick list field selected. See Pick List control properties.
  16. Click Save.
Related topics