Difference between revisions of "Field Names"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
Line 19: | Line 19: | ||
;Considerations: | ;Considerations: | ||
*When creating a field, the field name defaults to a the field label | :*When creating a field, the field name defaults to a the field label | ||
:*If spaces are part of the field name, the (<tt>_</tt>) underscore character is substituted for each space | ::*If spaces are part of the field name, the (<tt>_</tt>) underscore character is substituted for each space | ||
*To use a field in a [[Database View]], include the (<tt>#</tt>) hash character (also known as the sharp or pound sign) at the end of the fieldname (<tt>name_of_field#</tt>) | :*To use a field in a [[Database View]], include the (<tt>#</tt>) hash character (also known as the sharp or pound sign) at the end of the fieldname (<tt>name_of_field#</tt>) | ||
:*To reference a field in a [[Lookup]] record, use "dot notation". For example, since the Order object has a lookup field called <tt>customer</tt>, the customer's <tt>state</tt> field can be accessed using: <tt>customer.state</tt> | |||
::''Learn more:'' [[Referential Field]]s | |||
<noinclude> | <noinclude> | ||
[[Category:Glossary]] | [[Category:Glossary]] | ||
</noinclude> | </noinclude> |
Revision as of 22:47, 9 November 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:
- Java API, as part of function call parameters
- Value field for Record Selection Criteria
- Action URL used to Manage Related Information
To find the Field Name:
- Click Designer > Data > Objects > {object}
- Click the Fields tab
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 JavaScript, 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#)
- To reference a field in a Lookup record, use "dot notation". For example, since the Order object has a lookup field called customer, the customer's state field can be accessed using: customer.state
- Learn more: Referential Fields