Supported Salesforce Field Data Type Mappings

Back to Help Center

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

© 2021 GetFeedback, Inc.|888-684-8821|Privacy notice|California privacy notice|Terms of use|Cookie policy

*Net Promoter, Net Promoter System, Net Promoter Score, NPS and the NPS-related emoticons are registered trademarks of Bain & Company, Inc., Fred Reichheld and Satmetrix Systems, Inc.