Recode N/A response to null

Question

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

asporre · Accepted Answer

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.

CarolK · Answer

I think you can do one of two things.You can recode the values of the prompts such that N/A has a numeric recode value of 0You can select the N/A value to be excluded from analysis (basically will not get recorded; will be null/empty)

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded