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.
Target Field Types | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Source Field Types |
Lookup (source) | Lookup
(other obj) |
ID | Checkbox | Currency | Date | Date/ Time |
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 | — | — | — |
— | — | — | 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 |