Hello,
I am in the process of finalizing a directory setup that is fed by a survey. The survey feeds the directory via a workflow (specifically via embedded fields). I’ve tested multiple times and 90% of the fields are filing/logging in the directory correctly. However, there are 2 items giving me trouble:
- For one of the questions in the feeder survey, the answer options are formatted with bold and coloring/italics, as shown below.
| Fruit (Apples, blueberries, bananas) Other fruit includes strawberries, blackberries, etc. |
| Veggies (Peppers, carrots, onions) Other veggies include potatoes, spinach, etc. |
The only value I want in the directory is the category in bold (e.g., Fruit, Veggies). Instead it logs the full option as shown below, even after I recoded the values (and variable names) in the survey.
<strong>Fruit</strong><br />(Apples, blueberries, bananas)<br /><span style="color:#c0392b;"><em>Other fruit includes strawberries, blackberries, etc.</em></span>
- The other question giving me trouble is when I try to log a multi-select question in the directory (example question below). Instead of Qualtrics creating a column for each option, like it does with multi-select questions in survey raw data exports, it combines all selections into a single column as a string. So, if the respondent selects “Canada” and “Mexico” for example, it will store in the directory as a single column with a value of “Canada, Mexico”. Instead, I would like it to store as:
Q_Canada Q_Mexico Q_Columbia Q_Peru Q_None
Canada Mexico cBlank] dBlank] dBlank]
EXAMPLE QUESTION FOR ABOVE SCENARIO: Which country (or countries) have you had fruits or vegetables from? Select all that apply.
- Canada
- Mexico
- Colombia
- Peru
- None of these PEXCLUSIVE]
Please note that all examples above are hypothetical, so precise code might not apply. Thank you for your help!
