Composite fields

A composite field combines information from two fields in a table to form a single field.

For example, the Task field on the Project Tasks list displays the short description and the project task number. The short description appears above the project task number. The project task number appears and is a link to the Project Task form.

Figure 1. Composite field
Composite field

Use a composite field

  • Editing a composite field changes the short description. Editing the short description changes the composite field.
  • Sorting on a composite field is based only on the short description and not the number.
  • Searching on a composite field is enabled for both the short description and the number:
    • To search by the number using the list header, enter an asterisk (*) before the search term. For example, *PRJTASK0010016.
    • To search by the number using the filter, create a condition similar to: [Task] [contains] [PRJTASK0010016].