Survey Column Values

[jamie_bowers]

Hello everyone,

I have been working on the ability to report on our survey results in a more reader friendly format. I have created a database view to show all of the survey results in a single row and I have customized the column headers to reflect the questions instead of just "value" or "string value". However, I cannot figure out how to get the display names of the answers to show instead of the numerical value. 

Example: In the screenshot below, the column labeled "Follow Up Contact Requested" displays a value of 0 or 1. In reality the answer to the question is Yes/No. 

Any idea what element I would map this to for it to pull the Yes or No value instead of 0 or 1.

Thanks for any input!

[jamie_bowers]

Hi @AshishKM,

The other table I have mapped is 'asmt_assessment_instance_question'.

[jamie_bowers]

Hi @AshishKM ,

The other table I am mapped to is 'asmt_assessment_instance_question'.

[jamie_bowers]

Hi @AshishKM 

The other table I am mapped to is 'asmt_assessment_instance_question'. Screenshots attached.

[aj2171 · Accepted solution]

Hi @jamie_bowers,

Here are instructions I've used in the past to achieve a similar result. I hope this works for you!

1. Identify the name of the table containing the survey results and the corresponding table containing the survey questions and answers.
2. In the survey questions table, identify the field where the answers' display names are stored.
3. In the survey results table, find the field displaying numerical values (0 or 1) instead of the display names.
4. Navigate to the "System Definition" > "Database Views" > "All" menu.
5. Locate and open the database view corresponding to the table of survey results you wish to edit.
6. Navigate to the field that needs to display the display names (the field from step 3), then under the "Map field" column insert this syntax: survey_questions_table.field_with_display_names.
7. Replace survey_questions_table with the name of the table containing the survey questions, and replace field_with_display_names with the specific field name that holds the display names.
8. Save the changes and verify that the display names are now being shown in the corresponding field of the survey results table.