I need to pipe in a numeric value based on a zip code that the respondent types in. The problem is that I have ~33K zip codes, and the corresponding numeric values (distance in miles from a certain location) is different for each zip code.
I would like to ask an open-end zip code question, and then insert a text question in which I pipe in the numeric value corresponding to the zip code respondents type in on the first question. These two questions would be separated by a page break.
In Excel terms, this is basically a VLOOKUP, but I don't how to do this in Sawtooth.
Any suggestions?