How do I integrate a lookup table in Qualtrics | XM Community

How do I integrate a lookup table in Qualtrics

  • 17 March 2022
  • 2 replies
  • 261 views

Badge +1

Hello!
I am trying to create a form in Qualtrics that users will be able to input their zip code and it will tell them whether their zip code is urban or rural. I have a lookup table that contains the zip code and urban/rural designation, however I am not sure how I can do this in Qualtrics. I basically want to be able to create a vlookup style function in Qualtrics. Anyone have any ideas?

Thank you,

-Willy


2 replies

Userlevel 7
Badge +27

If it were me, I would store the zip codes in an external database and use a web service to do the lookup.

Userlevel 5
Badge +11

Hi @OHCS_analyst ,

 

You may have found an answer to this already but as of this week’s release notes, there is now a lookup task which might keep things simple: 

 

Hope that helps

 

Rod Pestell 

Leave a Reply