Field Display Types

Field Display Types

From LongJump Support Wiki

Field Display Types
Jump to: navigation, search

When a field is added to an object, the Field Display Type must be defined, as well as parameters specific to the field.

Examples

A Picklist might have these options:

  • Yes | No | Maybe
  • Strongly Disagree | Disagree | Not Sure | Agree | Strongly Agree
  • OK | Good | Better | Best
See Picklist for more information

A Date field might include:

  • Date only: 10/27/2008
  • Date and Time: 10/27/2008 11:30pm
See Date Format for more information

A Checkbox field is used for a Yes / No or True / False choice.

Supported Field Display Types

File:notepad.png

Note: The field types listed below are types you can choose when creating a field. In addition, there is a Multi Value Lookup type, which automatically appears in the Form field-list whenever two objects are joined by a many-to-many relationship.

Field Display Types Description
Auto Number
  • Generates a unique number based on simple format rules and provided with a starting value
  • Auto Number fields default to YYYY-MM-DD-{0000}, where the number between the curly braces {0000} increments automatically.
  • Curly braces {} are required to generate an auto number
  • The YYYY-MM-DD- prefix is optional. It generates values for year, month, and day.
  • Any prefix can be used.
Checkbox
  • A single check box, where the checked value is "Yes/True" and unchecked value is "No/False"
  • To apply a filter to a checkbox, or import a checkbox field, use:
Yes/True = 1 or No/False = 0
  • When specifying a formula for a default value, the formula must resolve to 1, 0, true, or false. (When typing it in directly, enter one of those values with no quotes around it.)
Currency Displays currency in the format determined by the user's locale.
Custom Control Custom Controls can be either: Components or Pages
  • Components are created using HTML and JavaScript to extend the functionality of web pages, objects, and their operations
  • Pages are built using HTML and JSP to display custom web pages
Date A date.
Date time A date and time.
  • As Entered - The date/time is stored and displayed exactly as entered.
  • Convert to Local Date/Time - (Default) Value is presumed to be entered in user's local time zone. The value is converted to the System Time Zone for storage in the database. When displayed, it is converted the user's time zone.
Note:
These options are available for new fields in Custom Objects and CRM Objects. They are not available for standard Date/Time fields (for example: modified_time) or for Date/Time fields in the Built-in Objects. Those fields are always converted.
Dependent Picklist
  • A picklist that is dynamic based on values provided in another field.
  • For example, a Picklist for T-Shirt Sizes might include entries for Adult, Teen and Child.
  • The Adult list might include entries for S, M, L, XL, and XXL sizes.
  • A Teens list might include similar entries, while the Child list might include entries for 0 - 6 mos., 6 - 12 mos., 1T, 2T, and 3T.
  • The resulting hierarchy would be:
  • Size
  • Adult
  • Adult Small
  • Adult Medium
etc.
  • Child
  • Child 0 - 6 mos.
  • Child 6 - 12 mos.
  • etc.
  • Teen
  • Teen Small
  • etc.

(Best practice is to include the entire hierarchy "path" in the entry, so that Adult Small is distinguished from Teen Small. If the entries said simply, "Small", a shipping clerk might not be able to tell which size was intended.)

Email Address A text string of the form {name}@{domain}.{type}. Example: friend@somewhere.com
File FieldAllows a file to be uploaded as part of the record
Formula

If the formula return type is a DateTime or Time, then the time zone conversion options are available:

  • As Entered - The date/time is stored and displayed exactly as entered.
  • Convert to Local Date/Time - (Default) Value is presumed to be entered in user's local time zone. The value is converted to the System Time Zone for storage in the database. When displayed, it is converted the user's time zone.
Note:
These options are available for new fields in Custom Objects and CRM Objects. They are not available for standard Date/Time fields (for example: modified_time) or for Date/Time fields in the Built-in Objects. Those fields are always converted.
Global Picklist
  • A Global Picklist is a type of field that contains a list of values, and performs much the same as a Picklist field
  • Global Picklists contain the kind of default values commonly used in all applications
Example: US states, status level, priority, hat size, apparel size, component part numbers, etc.
  • These predefined fields save time and can be used in any object.
  • When adding a Global Picklist field to an object, you select from the set of Global Picklists that has been defined for this application.
Image Field
  • Allows an image file to be uploaded as part of the record.
  • Allows a thumbnail width to be specified
    • Default is 100 pixels
    • The image is scaled proportionally to fit into that width
    • The thumbnail is then displayed in image records, instead of the full image.
Lookup
Multiple Checkboxes
  • Multiple checkboxes are displayed and are associated with a single field.
  • For example, choose your favorite movie genres:
Action / Adventure / Animation / Comedy / Drama / Romance / Documentary / Children's / Fantasy / Sport / Thriller / Western
  • Multiple checkboxes can be selected, for example: Comedy, Romance, Western
  • When you select this type for an object field, a text area lets you enter values.
    • Enter the names of the values, one per line, in the order they will be displayed.
    • When the user makes a selection, the value that is stored is the text entered on that line. So:
      1. If you change the order later, existing values are not affected.
      2. If you remove an entry at a later date, or change the spelling of a value, existing records that have that value are not affected. Either clean up the object data, or take that possible value into account in your design for backward compatibility.
  • If the user makes multiple selections, the value is stored as a comma-separated list. So:
    • If you change the order of the values, new values may be stored differently than old ones.
Multi Object Lookup A two stage-lookup where the user first selects the object to use, and then looks up a record in that object.
Multi Select Picklist

(Multi Select Global Pick List)

  • A picklist containing multiple values from a Global Picklist
  • Multiple values can be selected from the list and associated with a single field
Number A numeric (integer) field, for which you specify minimum and maximum values. The default minimum is 0. To go lower, specify a negative number, like -20. The maximum value is 999999999 (999,999,999). That number can be varied as well, up to the maximum integer size 2,147,483,647. (The smallest possible negative value is -2,147,483,646.)
Number with decimals A numeric field, for which you specify the number of decimal digits.
Percentage A decimal field in the range 0 to 1, for which you specify the number of decimal digits.
Phone/Fax A string of digits. If digits are entered with spaces and punctuation marks, they are displayed and edited in exactly that form. (For example, "123.456.7890".) If a string of digits is entered without formatting, that is the way it appears when editing, but it is automatically formatted when the field is displayed:
  • 7 digits ("1234567") displays as "123-4567".
  • 10 digits "1234567890" displays as "(123) 456-7890".
  • 11 digits ("12345678901") displays 1-234-567-8901
Note:
If the field has more than 11 digits, they are displayed as entered.
In that case, it's helpful to provide the desired formatting.
Picklist
  • A picklist is a type of field that contains a list of values, usually presented in a drop-down list; Examples:
  • Types of things: Animal, Vegetable, Mineral
  • T-Shirt Size: Extra Small, Small, Medium, Large, Extra Large
  • A single value can be selected from the list
  • When you select this type for an object field, a text area lets you enter values.
    • Enter the names of the values, one per line, in the order they will be displayed.
    • When the user makes a selection, the value that is stored is the text entered on that line. So:
      1. If you change the order later, existing values are not affected.
      2. If you remove an entry at a later date, or change the spelling of a value, existing records that have that value are not affected. Either clean up the object data, or take that possible value into account in your design for backward compatibility.
Radio ButtonsA list used to limit user selection to a single, specific value from a supplied list of values.
  • When you select this type for an object field, a text area lets you enter values.
    • Enter the names of the values, one per line, in the order they will be displayed.
    • When the user makes a selection, the value that is stored is the text entered on that line. So:
      1. If you change the order later, existing values are not affected.
      2. If you remove an entry at a later date, or change the spelling of a value, existing records that have that value are not affected. Either clean up the object data, or take that possible value into account in your design for backward compatibility.
Rich Text Area An HTML-formatted text area
  • HTML formatting can include font styles, such as Bold, Italics, numbered lists and bullets or images (logos or art)
  • Formatting tools are provided

Considerations:

  • <wbr> and </wbr> tags are not supported, as they are problematic when switching between edit and display modes. (To prevent issues, those tags are therefore removed before the content is displayed.)
Text Area
  • A multi-line Text area that can contain alphanumerics (A-Z, a-z, 0-9) and special characters: / @ . - $ %
  • Height and width are defined when the field is created
Text Field
  • A single-line Text that can contain alphanumerics (A-Z, a-z, 0-9) and special characters: / @ . - $ %
Time A time. For example, "6:50 PM".
  • As Entered - The date/time is stored and displayed exactly as entered.
  • Convert to Local Date/Time - (Default) Value is presumed to be entered in user's local time zone. The value is converted to the System Time Zone for storage in the database. When displayed, it is converted the user's time zone.
Note:
These options are available for new fields in Custom Objects and CRM Objects. They are not available for standard Date/Time fields (for example: modified_time) or for Date/Time fields in the Built-in Objects. Those fields are always converted.
URL A web address. For example: http://yourCompany.com

Personal tools