Recode N/A response to null | Experience Community
Skip to main content
Solved

Recode N/A response to null

  • May 11, 2022
  • 2 replies
  • 610 views
A
Forum|alt.badge.img

Hello,
We have a survey with several multiple choice questions that ask the respondent to give a rating of 1 through 10, but they can also select N/A if the question does not apply to them. We map these responses to a numerical field in Salesforce. The Salesforce field does need to be a numerical field so that we can generate reports/dashboards/calculations using the response data, so we cannot change those fields to text. When someone selects N/A in one of our survey questions, our mapping to Salesforce fails because the N/A response is the wrong type of data to populate the numerical field.
Is there a way to recode N/A responses to null or blank? Or alternatively, is there a way to set a condition on our mapping so that individual fields of the survey will only map to Salesforce if N/A is not selected? I know we can set conditions to determine if an entire survey response should map, but I don't see a way to set conditions for individual fields.
Thank you!
Amy

Best answer by asporre

Thank you, CarolK! We ended up recoding the N/A values to 0, but they were already set to be excluded from analysis. We decided to handle things in Salesforce. The 0 values are mapping to Salesforce, and then we are setting up a flow so that when the new record saves, the 0 values will be changed to empty.

2 replies

CarolK
Level 5 ●●●●●
Forum|alt.badge.img+47
  • CarolK
  • Level 5 ●●●●●
  • May 16, 2022

I think you can do one of two things.

  1. You can recode the values of the prompts such that N/A has a numeric recode value of 0

  2. You can select the N/A value to be excluded from analysis (basically will not get recorded; will be null/empty)

Carol, Sr Insights Consultant
A
Forum|alt.badge.img
  • asporre
  • Author
  • Answer
  • May 16, 2022

Thank you, CarolK! We ended up recoding the N/A values to 0, but they were already set to be excluded from analysis. We decided to handle things in Salesforce. The 0 values are mapping to Salesforce, and then we are setting up a flow so that when the new record saves, the 0 values will be changed to empty.

    Terms & ConditionsAccessibility statement