Field Type Compatibility Matrix

This section describes the types of fields that you can map on the source and target objects. If you map incompatible field types, an error is generated. When users run a rule, if there is a problem with the data being converted, a log entry is created. For instance, If you create a rule where a source text field length is 32, but the target field that it is mapped to has a length of 10, the data in the target field is truncated and only contains the first 10 characters.

Tip:

If the source and target field types that you want to map are not compatible, you can map the source field to a formula field and create a formula to generate the information you want.

Field Type Compatibility Matrix
  Target Field Types


Source Field Types
Lookup (source) Lookup (other
obj)
ID Checkbox Currency Date Date/
Time
Email Number (18.0) Number (16.0) Percent4 (4.4) Percent2 (4.2) Phone Picklist Picklist (Multi) Text (32) Text (10) Text Area Text Area (Long) Text Area (Rich) Text (Encrypted)

Time

URL
Auto Number True True True True True True True True True True True
Formula (Number) True True True True True True True True True True True True True
Formula (Text) True True True True True True True True True True
Roll-Up
Summary
True True True True True True True True True True True True True
Lookup True True True True True True True True True True True True
ID True True True True True True True True True True True True
Checkbox True True True True True True True True True
Currency (10.2) True True True True True True True True True True True True True
Number (18.0) True True True True True True True True True True True True True
Number (16.2) True True True True True True True True True True True True True
Percent (4.4) True True True True True True True True True True True True True
Date True True True True True True True True True
Date/Time True True True True True True True True True True
Email True True True True True True True True True True True True
Phone True True True True True True True True True True True True
Picklist True True True True True True True True True True True True True True
Picklist (Multi-Select) True True True True True True True True True True True True
Text (32) True True True True True True True True True True True True True True True
Text Area True True True True True True True True True True True True True
Text Area (Long) True True True True True True True True True True True True True
Text Area (Rich) True True True True True True True True True True True True True
Text (Encrypted) (10) True True True True True True True True True True True True True True
Time   True True True True True True True
URL True True True True True True True True True True True