How to display full state name using embedded data and content validation?

Question

Hello,My survey currently has a form question that asks respondents for their City and State. The state question has the US State validation setting selected.I store respondents' answers to the state Q as Embedded Data (see the last row):On the next page, I ask respondents how many years they have lived in their state (using the embedded data labels). "About how many years have you lived in ${q://QID678/ChoiceTextEntryValue/2}?"This works fine, but it displays the state exactly as the respondent worded it (e.g., About how many years have you lived in ca?") My problem: I would like to display the properly capitalized, full name of the state in the second question. So, for example, if the respondent enters "ca", I would like the second question to ask "How long have you lived in California?" (A less ideal but acceptable solution would convert "ca" to "CA".) I also don't want to have to use an external dataset to do this, if possible.I understand that I can do this if I ask respondents for their zip code (see link), but I don't know how to simply clean up the state abbreviation respondents have already entered. Any help would be very much appreciated! Thanks.

npetrov937 · Answer

I think Qualtrics is using ISO 3166-2 standardfor the state names.Create a javascript object that contains key-value pairs with abbreviations as keys and full names as values. Then simply look up the participant's response in that object. Don't forget to make the lookup case insensitive. If Qualtrics is using that dataset AND you have validation, then, unless the response is blank, you should not have to do any further error handling.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded