Multiple choice response options pulled from CSV or SQL? | XM Community
Skip to main content
Question

Multiple choice response options pulled from CSV or SQL?

  • October 19, 2020
  • 1 reply
  • 22 views

We need to match ZIP codes to neighborhoods/towns for a survey in an urban area. We have a CSV file with ZIP codes and neighborhoods. In some cases a ZIP code intersects with several neighborhoods.
Thus, we need to ask a follow-up multiple choice question that asks respondents which of the matching neighborhoods they actually live in. Basically we need to pull the array of neighborhoods that match the ZIP code the respondent enters; then list them as multiple choice options.
I have some background with PHP and SQL, but am a total JS novice.
Thanks!

1 reply

TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • Level 8 ●●●●●●●●
  • October 19, 2020

Take a look at select2's ajax option.