Hello everyone,
We’re looking to program a new survey and as part of this ask we’ll have respondents enter a 6 digit identifier that will represent one of our offices across the country. We have an excel of the data tied to each of those unique identifiers that we’d like to connect into the survey data.
So for example:
- Our location excel sheet tells us that office #123456 is located in Toronto and is managed by John Smith.
- Respondent takes the survey and says they visited office #123456
- In the survey response data the location (Toronto) and the manager (John Smith) needs to be pulled into that response automatically for filtering down the road - this would most likely be embedded data.
Now if we only had a few of these to build I could do this manually but our list of offices is 6000 long and there are multiple data points we’d want to capture for each of those locations.
What is the best way to accomplish this? Not sure if it’s javascript somehow or web service...I don’t have the technical background knowledge but if I know what route to go I can start digging around to see if someone can do it :)
Thanks!
