Record Id

From AgileApps Support Wiki
Revision as of 00:29, 4 February 2011 by imported>Aeric (→‎For Developers)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Each record has a unique identifier, which is the key to accessing or updating data and moving records through workflows. Record Identifiers are typically not displayed in Views or Reports, however, some users (and developers, especially) find it useful to know the value of the Record Identifier. In APIs and Formula Expressions, Record Identifier can appear as: id, record_id, or recordId, depending on the tool.

The Record Identifier is contained in a field like any other, and can be displayed from a View or a Report.

Find Record Identifier from the Web Browser

  1. Open the object of interest
  2. Click the View Icon and select Edit this View
  3. In the Fields tab, select the Record Identifier from the Available Fields list, and move it to the Selected Fields list
    • Each selected field becomes a column in the resulting view
  4. Save the view

Record Identifier and Lookup Actions

  • The Record Identifier of any field that is of type Lookup can be retrieved by using the get method of the Parameter class with 'Field Name' as the parameter
  • Record Identifier has a Range of: 1 - 2,147,483,647
  • In most Objects, the record identifier is formatted as an integer
Exception
In the following objects, the record identifier is formatted as a text string
  • Lookup actions require that the field is formatted as a text string
To convert Record Identifier to string format, use the CONCAT Formula Function:
CONCAT (id, '')

    where: 
          id is a Record Identifier
          '' is two single quote (') characters

About Field Names

Field Names are listed in the Fields tab of an Object.

For Developers

Using the Developer Suite, the Record Identifier can be requested from:

See Also