General Field Settings

General field properties are set in SBM Composer, but you can view them in Application Administrator. The following table describes these properties.

Field Property Description Applicable Field Types
Name and Description Settings

Logical Field Name

Indicates the name of the field as it appears to users. You can change this name in SBM Composer.

All

Database Field Name

Indicates the field name as it is stored in the database. The database field name cannot be changed or removed.

All, except Sub-Relational

End-user help text

The text entered here is displayed to users who hover the mouse pointer over the field name and in a help window users can opens from forms.

Use the scroll bar to view long descriptions. To hide the text, collapse the General section.
Note: HTML tags provided in SBM Composer are not rendered.

All

Relationship

Table

Indicates the relational field table.

Single Relational and Multi-Relational

Relational Field

Indicates the Single Relational field associated with the Sub-Relational field.

Sub-Relational

Sub-Field

Indicates the field from the relational field table whose value will be displayed on forms.

Sub-Relational

Display and Query Settings

Spans Entire Row on Forms

If selected, this check box indicates that the field will appear on a single row on quick forms. If this check box is cleared, the field appears with another field on a row.

All field types, except Text fields that are set as memo fields or fixed length fields whose length is greater than the Max Text Field Size setting for your database. This settig is located on the Display tab of the Settings dialog box in SBM System Administrator.

Appears in Report Field List

When this check box is selected, the field is included on report forms. This enables you to simplify field lists for users who are creating reports. Depending on the type of field you are creating, when the Appears in Report Field List check box is selected, the field appears in the Field Specification, Select Columns to Display, Add Columns of Calculations, and Sorting lists on report forms. The field is also included in the Row and Column lists on Distribution reports and the Trend lists on Trend reports. By default, the Appears in Report Field List check box is selected. In addition, if a field is used on a report and the Appears in Report Field List check box is later cleared, the setting is ignored for that report.

All

Appears on Lookup Form and Relational Field Value Lookup

If this check box is selected, the field is added to the Auxiliary Data search form in SBM Application Administrator and the Advanced Lookup Tool and Relational Field Value Lookup forms.
Tip: The field order for the Advanced Lookup Tool and Relational Field Value Lookup forms is determined by the default field order of the table's first project in the project hierarchy. To display fields in a different order, add another project to this hierarchy, clear the Allow New Items to Be Submitted check box, and drag the project to the top of the hierarchy for this table. You can also remove all user privileges for this project so that the project is only used to determine field order for search forms.

Allow Searching

This option enables Value Find and Relational Field Value Lookup capability for the field. Value Find allows users to enter search criteria, such as an entire word, a few letters, or an asterisk, and then click a search icon or press Enter to perform the search. Results appear in a list, allowing users to select a value for the field. Relational Field Value Lookup provides an advanced searching mechanism that enables user to find values for Single Relational and Multi-Relational fields. If enabled, an additional search icon is available.

Folder, Single Relational, Multi-Relational, Single Selection, Multi-Selection, User, Multi-User, and Multi-Group fields

Show Full List

This option allows users to select a value from a fully populated list rather than search for values.

Folder, Single Relational, Multi-Relational, Single Selection, Multi-Selection, User, Multi-User, and Multi-Group fields

Automatically Prepend Wildcard to Lookup Text

When this check box is selected, wildcard characters are prepended to the search text for this field as long as there are no wildcard characters within the text. This allows users to easily search for keywords. When this check box is selected, a percent sign (%) appears next to the field on Advanced Lookup Tool and Relational Field Value Lookup forms and on the Auxiliary Data search form in SBM Application Administrator. Note that when this check box is cleared, a wildcard character is automatically appended to the entered search text as long as there are no wildcard characters within the text.

Text fields, except for the Item ID system field