Create Fields

Owned by Brian Banet
Last updated: Oct 04, 2022
4 min read

  1. On the Field Catalog toolbar, click Fields. A list of Fields in the database will appear.




  2. Click the Add () button to create a new Field.

     

  3. Enter a name for the new Field in the Field Name text box.


  4. Select a data type from the Data Type drop-down list. (Refer to the Field Data Types page for details.)


  5. To display the Field with a certain format or layout (for example, a date with a two-digit year), enter the format type in the Format text box. Refer to Values for Formatting Index Fields for a list of format patterns.


  6. Enter the maximum number of characters in a Character Field, up to 8000 characters, into the Length text box.


  7. Regular expressions can be leveraged with Key Free Indexing, to speed up indexing or for controlling user input on Character field types. For details on this feature, refer to the documentation here.

  8. Regular expressions can be used to control formatting and are also leveraged to speed up indexing with Key Free. Click here for details on using patterns.

  9. To set Field Properties or system values, in the Field Properties group, enable one or more of the Required, Multi-value, or System Field checkboxes. Refer to the Field Properties page for details

    Before creating a Dynamic Pick List, create any Standard Pick Lists needed for the Dynamic Pick List. Refer to the “Create, Edit, and Delete Field Lists in the Web Client” section above for details on Field Lists. There are two levels of dependency that you can specify for a Dynamic Pick List. The primary level is required and contains a list of standard Fields List values. The secondary level is optional and may have conditional Fields besides regular Field List values. Refer to the List Options page for more information on Dynamic Pick Lists.



  10. To assign, or create and assign, a Standard Pick List to an Index Field:

    1. Click List Options.

    2. In the List Options dialog box, add a List by changing the default of Normal Field to Dynamic Pick List.

    3. Select a Field with a Standard Pick List from the Select a list drop-down list.

      1. For a single level of dependency, skip step d and proceed to building your List.

    4. To select controlling Fields for an optional second-level Dynamic Pick List, enable Secondary Dependency and select a second Field with a Standard Pick List from the Select a field list.

    5. To map the relationship between the List and the Field, click Build List.

    6. In the Edit List Mapping dialog box, in the Select filter 1 drop-down list, select a value for the first row.

    7. If creating a two-level Dynamic Pick List, from the Select filter 2 drop-down list, select a value from the List associated with the dependent Field.

      1. This column will not appear in the Edit List Mapping dialog box for a single-level Dynamic Pick List.

    8. Select a Field List in the Select alist column for each row.

    9. Repeat steps f through h for each keyword associated with the dependent Field. Map all possible combination that you wish to offer so that the Dynamic List Field can be displayed correctly.

      1. You will see an error message in the Document Viewer for an unmapped combination.

    10. Click Save to return to the List Options dialog box.

    11. In the List Type group, select Drop Down. Refer to the Types of Lists page for details.

    12. Click OK and return to the Edit dialog box


  11. Click Save.