Difference between revisions of "Record Identifier"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 1: Line 1:
'''Designer > Data > Objects > {object} > [Record Locators] > Record Identifier Fields'''
'''Designer > Data > Objects > {object} > [Record Locators] > Record Identifier Fields'''


A ''Record Identifier'' consists of one or more fields that, together, uniquely identify a record in an Object. That combination of fields can then be used as a [[Record Locator]].
A ''Record Identifier'' consists of one or more fields that are displayed when a record has been ''selected''. For example, the field values are shown, separated by hyphens, as the value of a [[Lookup]] field.


====About Record Identifiers====
====About Record Identifiers====
A Record Identifier is a unique label that distinguishes one record from another. These labels can be seen in [[Views]] and [[Records]].
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: {{ShowIsvInfo}} |
{{#if: {{ShowIsvInfo}} |
If the App Center is not enabled, then the <tt>record_id</tt> field is the only field used for Record Locators. Otherwise:
If the App Center is not enabled, then the <tt>record_id</tt> 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.  
: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.  


==== Example ====
==== Example ====
In this example, the Customer object specifies the <tt>customer_name</tt> field might as the Record Identifier:
In this example, the Customer object specifies the <tt>customer_name</tt> field might as the Record Identifier. When the customer has been selected in a [[Lookup]], the <tt>customer_name</tt> field is displayed to indicate which record was chosen.


:[[File:RecordIdentifierFields.png]]
:[[File:RecordIdentifierFields.png]]

Revision as of 23:45, 2 August 2011

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

A Record Identifier consists of one or more fields that are displayed when a record has been selected. For example, the field values are shown, separated by hyphens, 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.

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.

Example

In this example, the Customer object specifies the customer_name field might 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.

RecordIdentifierFields.png

Fields Available for Use as Record Identifiers

In general, fields that are available for use as record identifiers resolve to a single alphanumeric value of moderate size. With few exceptions, fields of these types are not available for use:

  • File
  • Image
  • Rich Text Area
  • Checkbox
  • Custom Control
  • Rollup Summary