Comment Column Value Matrix
The following table displays the value matrix for the Comments column of different expressions.
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.
Was this helpful?