Is there a way to import choices from excel based on input from a previous question? | XM Community
Question

Is there a way to import choices from excel based on input from a previous question?

  • 24 October 2019
  • 1 reply
  • 27 views

Hi,

I'm doing a project where I would like to import choices depending on the persons name (either manually put in or selected in a drop-down list). I have around 40 persons that I would like to tailor the possible options for. For example, I have 700 options on what Person1 could spend time on, but I know that only 30-50 options are relevant for Person1 from my excel-list, which means that I seek the logic (IF name = Person1, display X options as sliders where the total time spent should add up to 100%).

I'm not sure how to do this in an efficient way without too much coding, which is both too complicated and too risky for me to use in this survey.

Thanks in advance,

1 reply

To clarify, otherwise my current options are to
1. Display all alternatives for all persons which is inefficient and time-wasting.
2. Create a question for each person and use "Add Display Logic" depending on name

Leave a Reply