Record Locators

Record Locators

From LongJump Support Wiki

Record Locators
Jump to: navigation, search

Designer > Objects > {object} > [Record Locators]

The Record Locator option (available for Custom Objects only) provides the ability to define three types of fields by which you can locate records in objects.

As a good practice, Record Locator fields should always have a value; they should never be empty.

Contents

Kinds of Record Locators

Lookup and Search Results Fields

The fields selected in this option appear as columns in a Lookup Window when the user is selecting a record, and in a grid display of Search results. In both cases, they help the user to select the record(s) of interest.

This value is also returned as a record's "displayValue" attribute in REST APIs.

Record Identifier Fields

Designer > Objects > {object} > [Record Locators] > Record Identifier Fields

A Record Identifier (also known as a "record name") consists of one or more fields that are displayed when a record has been selected. (When multiple fields are specified, their values are separated by hyphens and displayed as the value of a Lookup field.)

About Record Identifiers

Ideally, a Record Identifier unique label that distinguishes one record from another (although it need not be). These labels can be seen in Views and Records. If the App Center is not enabled, then the record_id field is the only field used for a Record Identifier. Otherwise:

When a new object is created, the first three fields defined in the object are used to form the default Record Identifier. The Record Identifier can be changed at any time.

File:thumbsup.gif

Tip: To ensure that the record identifier is unique, use it to define a Unique Key Index.

Example

In this example, the Customer object specifies the customer_name field as the Record Identifier. When the customer has been selected in a Lookup, the customer_name field is displayed to indicate which record was chosen.

File:RecordIdentifierFields.png

Eligible Record Identifier Fields

In general, fields that are available for use as record identifiers resolve to a single alphanumeric value of moderate size.

One Lookup field may be specified.

These fields cannot be used:

  • File
  • Image
  • Text Area
  • Custom Control
  • Url
  • Rich Text Area

Search Fields

This option defines the field(s) in a record that are used by the search process. When choosing fields as search fields, it is good practice to choose fields likely to contain unique information and to exclude large text fields, which can slow the process.

The first 1024 characters of the concatenated field value(s) are used when searching for a match. For example, if a Text field of 30 characters and a Text Area field of 2000 characters are designated, the search examines the concatenation of 30 characters from the Text field and the first 994 characters from the Text Area.

Search Field Example

For example, in a Parts Inventory object, the most likely fields to search are:

  • part number
  • part name

With that specification, even though fields part_description and price exist, they would not be "searchable".

Eligible Search Fields

In general, fields that can be used as record identifiers resolve to a single alphanumeric value.

One Lookup field may be specified.

These fields cannot be used:

  • File
  • Image
  • Checkbox
  • Custom Control
  • Rollup Summary

Updating Record Locators

To update an object's record locators:

  1. Click Designer > Objects > {object}
  2. Click the [Record Locators] button
  3. Select the fields you want to use as Lookup and Search Results Fields in the Available column, and click the right-arrow button to move the field(s) into the Selected list. Use the up- and down-arrow buttons to arrange the order in which they appear in the Lookup window (from left to right). These are the columns that will appear in the Lookup window. The name field appears as the default column, which you can keep or remove.
  4. Select the fields(s) you want to serve as Record Identifier Fields, and move them to the Selected list. These are the fields through which you can link objects together. You can keep or remove the default field.
  5. Select the field(s) you want to use as Search fields, and move them to the Selected list. You can keep or remove the default field.
  6. Click [Save].
    The fields you selected are shown.
Personal tools