Difference between revisions of "Field Name"

From LongJump 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:

To find the Field Name:

  1. Click Designer > Data > Objects > {object}
  2. 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