Data Types
|
Value
|
---|---|
Lookup
|
This datatype accepts values related to a specific object's name field.
|
Picklist
|
This datatype allows user
s to select a value from a list you define.
|
Multi-Picklist
|
This datatype allows users to select multiple values from a list you define.
|
Checkbox/Boolean
|
This datatype allows users to select a True (checked) or False (unchecked) value.
|
Number Formula (Number)
|
This datatype will accept numbers as values.
|
Currency
|
This datatype allows users to enter a dollar or other currency amount and automatically formats the field as a currency amount. This can be useful if you export data to Excel or another spreadsheet.
|
Formula
|
A read-only field that derives its value from a formula expression you define. The formula field is updated when any of the source fields change. There can be sub-types: Number Formula or Text Formula.
|
Auto Number (Name)
|
A system-generated sequence number that uses a display format you define. The number is automatically incremented for each new record.
|
Percentage
|
This datatype allows users to enter a percentage number, for example, '10', and automatically adds the percent sign to the number.
|
Time
|
This datatype allows users to enter a local time. For example, "2:40 PM", "14:40", "14:40:00", and "14:40:50.600" are all valid times for this field.
|
Date
|
This datatype allows users to enter a date or pick a date from a popup calendar.
|
Date/Time
|
This datatype allows users to enter a date and time or pick a date from a popup calendar. When users click a date in the popup, that date and the current time are entered into the Date/Time field.
|
Geolocation
|
This datatype allows users to define locations. Includes latitude and longitude components and can be used to calculate distance.
|
Email
|
This datatype will accept only valid email aliases.
|
URL
|
This datatype allows users to enter any valid website address. The URL will open in a separate browser window when the users click on the field.
|
Text
|
This datatype allows users to enter any combination of letters and numbers.
|
Text Area
|
This datatype allows users to enter up to 255 characters on separate lines.
|
Roll-up summary
|
A read-only field displays the sum, minimum, or maximum value of a field in a related list or the record count of all records listed in a related list.
|
Phone
|
This datatype allows users to enter any phone number. Automatically format it as a phone number.
|