AgileApps Support Wiki Pre Release

Difference between revisions of "Field Names"

From AgileApps Support Wiki
imported>Aeric
m (Text replace - 'Data & Presentation > Objects' to 'Data > Objects')
imported>Aeric
Line 1: Line 1:
''Field Name'' is defined as the name of a field in an object, and the contents of the field is the ''Field Value''. In a [[View]], ''Field Names'' appear as column headings, and ''Field Values'' appear as the row content:
''Field Name'' is defined as the name of a field in an object, and the contents of the field is the ''Field Value''. In a [[View]], ''Field Names'' appear as column headings, and ''Field Values'' appear as the row content.
:[[File:listview.gif|none|thumb]]


''Field Names'' and ''Field Values'' are used in these areas of the platform:
''Field Names'' and ''Field Values'' are used in these areas of the platform:

Revision as of 18:14, 21 July 2011

Field Name is defined as the name of a field in an object, and the contents of the field is the Field Value. In a View, Field Names appear as column headings, and Field Values appear as the row content.

Field Names and Field Values are used in these areas of the platform:

To find the Field Name:

  1. Click Designer > Data > Objects > {object}
  2. Click the Fields tab
File:Fieldslist.gif
Field names in Objects

To reference the Field Value:

Append ".value" to the Field Name fieldname, to create fieldname.value
Example
A typical field used in accounts and contacts is "email". When referencing the field name and the field value in Scripting, use this syntax:
fieldname = "email"
fieldname.value = "support@mycompany.com"
Considerations
  • When creating a field, the field name defaults to a the field label
  • If spaces are part of the field name, the (_) underscore character is substituted for each space
  • To use a field in a Database View, include the (#) hash character (also known as the sharp or pound sign) at the end of the fieldname (name_of_field#)