For example:
The respondent answers a question asking for their zip code (a text entry question).
I have an Excel file that links each zip code with the latitude and longitude of the "center" of the zip code.
I would like to define two embedded variables, one for the latitude and one for the longitude that corresponds to the zip code given by the respondent.
There are solutions that use branching or drill down variables, but so far these would involve too much work (one branch for every zip code in the US for example), or would require the user to select the lat and lon after picking their zip code. Kind of awkward to have the respondent see the lat and lon at all. Would like this process to happen behind the scenes.
Thanks.
Best answer by MohammedAli_Rajapkar
View original