AgileApps Support Wiki Pre Release

Difference between revisions of "Record Id"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 4: Line 4:
The Record Identifier is contained in a field like any other, and can be displayed from a [[View]] or a [[Report]].  
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==
==Get a Record Identifier from the Platform UI==
#Open the tab for the object of interest
#Open the tab for the object of interest
#Click the down arrow next to the name of the current view ([[File:DownArrowIcon.png]])
#Click the down arrow next to the name of the current view ([[File:DownArrowIcon.png]])

Revision as of 20:21, 12 June 2014

Each record has a unique identifier, which is the key to accessing and updating data. 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.

Get a Record Identifier from the Platform UI

  1. Open the tab for the object of interest
  2. Click the down arrow next to the name of the current view (DownArrowIcon.png)
  3. Click [Edit]
  4. In the Fields tab, select the ID field in the Available Fields list, and move it to the Selected Fields list.
    (Each selected field becomes a column in the resulting view.)
  5. Save the view

Notepad.png

Note:
This option is available only for views that have a sidebar.

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

For Developers

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

See Also