How do I integrate a lookup table in Qualtrics | Experience Community
Skip to main content

How do I integrate a lookup table in Qualtrics

  • March 17, 2022
  • 2 replies
  • 588 views
OHCS_analyst
Forum|alt.badge.img+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

TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • TomG
  • Level 8 ●●●●●●●●
  • March 18, 2022

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

R
Level 4 ●●●●
Forum|alt.badge.img+11
  • Rod_Pestell
  • Level 4 ●●●●
  • March 14, 2024

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 

Terms & ConditionsAccessibility statement