Every field within Salesforce has a defined data type. When these fields are created in Salesforce, you are prompted to choose its data type such as String, TextArea, Number, PickList, etc. It's important to understand that these fields expect data of a certain type.
For example, when you use the Salesforce application, you cannot put a long string of text into a field that expects a number value. The same is true when you're using GetFeedback to map answer values into your Salesforce instance via Custom Mappings.
Below is a list of supported Salesforce field data types that you can map responses to based on the types of question in your survey:
GetFeedback Question Type | Salesforce Field Data Type |
Custom Effort Score (CES)* | Number, Text, or Text Area |
Customer Satisfaction Score (CSAT)* | Number, Text, or Text Area |
Form | Text, Text Area, Email, Number, Website, or Date |
Image Upload | URL field |
Key Driver (item) | Number, Text, or Text Area |
Like or Dislike** | Text, Text Area, or Checkbox |
Multiple Choice | Text, Text Area, Picklist or Picklist (Multi-Select) |
Multiple Choice Multi-Select | Text or Text Area |
Multiple Choice Comment | Text or Text Area |
Multiple Choice Grid (Item) | Text, Text Area, Picklist or Picklist (Multi-Select) |
Net Promoter Score (NPS) | Number, Text, or Text Area |
Picture Choice | Text, Text Area, Picklist, Picklist (Multi-Select) |
Rank | Text or Text Area |
Rating | Number, Text, or Text Area |
Rating Grid (Item) | Number, Text, or Text Area |
Short Answer | Text, or Text Area, Text Area (Long) |
Slider Bar | Number, Text, or Text Area |
*Please note: For CES and CSAT survey questions, you have the option of mapping only the score a respondent gives or the score alongside its accompanying text ( i.e. 5 -Very Satisfied). To map only the numeric score a respondent gives, you'll want to map the survey response to a number data type field in Salesforce. For the score and the accompanying text, you'll want to map the survey response to a text data type field in Salesforce.
**Please note: Like/Dislike questions will map to Salesforce as text - Like (thumbs up or smiley face), Neutral (neutral face), or Dislike (thumbs down or frown face). If you require a numeric value, you can create conditional field mappings for each answer option, and map a fixed numeric value instead of the text (for example - Map a fixed value > when the answer to the like/dislike question is “Like” > value should be 1). An alternative workaround would be to create a formula field in your Salesforce object.
Below is a list of supported Salesforce field data types that you can map response attributes to:
GetFeedback Survey Response Attribute | Salesforce Field Data Type |
Survey Name | Text, Text Area,Text Area (Long) |
Start Time | Text, Text Area, Text Area (Long), Date |
Completion Time | Text, Text Area, Text Area (Long), Date |
Link to Response | Text, Text Area, Text Area (Long), URL |
Link to Summary Report | Text, Text Area, Text Area (Long), URL |
API ID | Text, Text Area, Text Area (Long), Number |
Full Text | Text Area (Long) |
Language | Text, Text Area, Text Area (Long) |
Language Code (ISO 639-1) | Text, Text Area, Text Area (Long) |
Browser | Text, Text Area, Text Area (Long) |
Platform | Text, Text Area, Text Area (Long) |
Question Type (only on Managed Mappings) |
NetPromoter |
CustomerEffort |
CustomerSatisfaction |
KeyDriver |
LikeDislike |
PictureChoice |
ShortAnswer |
MultipleChoice |
MultipleChoiceGrid |
Form |
FileUpload |
Rank |
Rating |
RatingGrid |
Slider |
SalesforceLead |
SalesforceContact |
SalesforceCase |