Data that you import, connect, or create in Salesforce Spiff must match a supported data type.
Required Editions
| Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience |
| Available in: Enterprise, Unlimited, and Developer Editions |
| Available for an additional cost in: Professional Edition with Web Services API Enabled |
Important The data type that you select for
each imported field must remain consistent when you import updated data later. Changing the
data type for a field between imports can cause calculation errors. If you select an
incorrect data type at first, reimport the data with the correct data type
applied.
| Data Type | Description |
|---|---|
| String | Numbers, letters, and symbols. |
| Integer | A number with no decimal, such as 100. |
| Decimal | A number with allowed decimal places, such as 100.25. |
| Boolean | True or false |
| Currency | Any integer or decimal number that's a currency value, such as $17.50. |
| Date | A year, month, and day. |
| Date & Time | A date that includes a time stamp. |
| Enumeration | A list of items in a group of collection, such as values in a Salesforce picklist. |
| Normalized Percent | An integer representation of a percent value, such as 50 for 50%. |
| Percent | A decimal representation of a percent value, such as 0.5 for 50%. |
| Time | Not supported. Use Date & Time instead. |