How can I set up pre fill for city/town based on post code? (German/Austria/Switzerland) | Experience Community
Skip to main content
Solved

How can I set up pre fill for city/town based on post code? (German/Austria/Switzerland)

  • Dec 9, 2019 6:15 AM UTC
  • 6 replies
  • 644 views

Forum|alt.badge.img
Hey, I am trying to validate addresses entered by respondents within the survey as much as possible. Wondering if anyone could help me. I would like the respondent to be able to enter their post code in and the city/town they live in is pre-populated to minimise errors. Can anyone help?

Best answer by C_Bohn

One built-in way you might approach this is to use a Drill Down question and its subsequent set up. This would require that you populate three columns with "Post Code", "City", "Country". You would then upload this into Qualtrics, as described in the instructions found here. This way only cities/towns and countries that apply to that post code are shown, while still allowing the respondent to select the appropriate (if needed). I suspect in most cases the post code will only show one city/town and one country, thus limiting and "auto-populating" the appropriate content to those fields.
View original

6 replies

C_Bohn
Level 2 ●●
Forum|alt.badge.img+2
  • Level 2 ●●
  • Answer
  • Dec 9, 2019 4:43 PM UTC
One built-in way you might approach this is to use a Drill Down question and its subsequent set up. This would require that you populate three columns with "Post Code", "City", "Country". You would then upload this into Qualtrics, as described in the instructions found here. This way only cities/towns and countries that apply to that post code are shown, while still allowing the respondent to select the appropriate (if needed). I suspect in most cases the post code will only show one city/town and one country, thus limiting and "auto-populating" the appropriate content to those fields.

Forum|alt.badge.img
  • Author
  • Dec 19, 2019 2:43 AM UTC
Fantastic! Thank you! 😀

Forum|alt.badge.img
  • Author
  • Dec 19, 2019 10:53 PM UTC
Ok - one follow up question. Germany has nearly 17000 post codes :o but I can only upload spreadsheets for the drill down question of a maximum of 10,000 rows. Any advice on what I can do? Thanks in advance :)

C_Bohn
Level 2 ●●
Forum|alt.badge.img+2
  • Level 2 ●●
  • Dec 20, 2019 3:43 PM UTC
@melissa_b One idea might be to ask a question, "Which region of Germany do you live?" and give the options - Bavaria, Berlin, Saxony, Macklenberg-Vorpommern, etc. Then have that question branch into one of 16 questions that contain the post-code drill downs for that region. If that is too many regions, is there another way to group areas of Germany that respondents would understand - and correctly select?

Forum|alt.badge.img
  • Author
  • Dec 23, 2019 3:17 AM UTC
Thank you for that idea! I will try and get the regions from our logistics company so I can make that happen! :) Fingers crossed I can get the info I need!

TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • Level 8 ●●●●●●●●
  • Dec 23, 2019 5:29 PM UTC
@melissa_b, You can register for an account at geonames.org, then use a web service call to the postalcode api from the survey flow to lookup the city based on the postal code. It would look something like this: !