Display fixed data based on answer to previous drop down question | Experience Community
Skip to main content
Question

Display fixed data based on answer to previous drop down question

  • August 27, 2020
  • 2 replies
  • 118 views
T

Based on different answers to a drop down menu question (in this case a location), I want to display data (in this case a date) that gives information about when an event will occur based on the survey taker's location. So, for example, if they select London, they would be told the event will take place on 1st June but if they said Manchester, the event takes place on 1st July.
How do I do this in the most efficient way? I have a drop down list of 145 locations, each will have a different event date. Can I pull this data from a live spreadsheet or will each data point have to be added manually?

      2 replies

      rondev
      Level 6 ●●●●●●
      Forum|alt.badge.img+22
      • rondev
      • Level 6 ●●●●●●
      • August 27, 2020

      You can make use of authenticator and contact list. Create a contact list, with same location name as present in the drop down question as the external data reference and add an embedded data (eg: EventDate) to this contact list named as date and set its value based on location.
      Now, in survey after this drop down question,in survey flow capture the selected drop down question answer in an emebedded data (Eg: SelectedLocation) using pipe text.
      Add autheticator below this and check auto fill option and enter the embedded data name (SelectedLocation). Authenticate same contact list and on external data reference. Now just create embedded data under authenticator (EventDate) and leave its value blank.
      You can now use this embedded data - EventDate in your further questions.

      Ron Dev (DM for any request. XM Technology Consultant, surveysolution.in)
      T
      • TomLove
      • Author
      • August 27, 2020

      Thanks for your quick response! I think there are a number of steps in your answer that I'm not completely familiar with (pretty new to Qualtrics!).
      To Clarify:
      For the first drop down list question (locations) do I need to pull these answer options from a contact list which includes both the SelectedLocation and EventDate fields and choose the SelectedLocation field to populate the options? At the moment I just copied and pasted the loactions into the drop down choices. If this is the case, I'm not sure exactly how to do this.
      I have uploaded the location and event date data to my library but I can't work out how to capture this after the drop down question using the survey flow. It only let's me place it after the block of questions.
      Sorry, I think I might be a bit out of my depth here. Feels like it should be simple, but it's making my brain hurt!

      Thanks for your help.

      Terms & ConditionsAccessibility statement