Difference between revisions of "Field Names"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 14: Line 14:
:Append <tt>".value"</tt> to the Field Name <tt>fieldname</tt>, to create <tt>fieldname.value</tt>
:Append <tt>".value"</tt> to the Field Name <tt>fieldname</tt>, to create <tt>fieldname.value</tt>
:;Example:  
:;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:
::A typical field used in accounts and contacts is "email". When referencing the field name and the field value in [[JavaScript]], use this syntax:
:::<tt>fieldname</tt> = "email"  
:::<tt>fieldname</tt> = "email"  
:::<tt>fieldname.value</tt> = "support@mycompany.com"  
:::<tt>fieldname.value</tt> = "support@mycompany.com"  
Line 22: Line 22:
:*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>)
 
<noinclude>


[[Category:Glossary]]
[[Category:Glossary]]
</noinclude>

Revision as of 02:03, 7 October 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#)