Skip to main content

Feature Spotlight: Dynamic Lookup Tables


In this Feature Spotlight we are focused on dynamic lookup tables. Dynamic lookup tables are an efficient way of categorizing and organizing data. Dynamic lookup tables can be used to segment data and allows for users to select one category before being shown the next. You have two main options when using a lookup table: a drop down box or a keyword search. Continue reading to learn more about dynamic lookup tables, see how to add them to your survey, and see how they look on mobile.




Add a dynamic lookup table to your survey first by clicking "Add a Question". Scroll down to the advanced question types, and under the Data/ Reference category, you will see Dynamic Lookup Tables. Dynamic lookup tables are an intuitive and efficient way of organizing data. For example, if you wanted to ask your survey respondents which college/ university they went to, the list could be thousands of lines long. Instead, you can segment the data by having the region, state, and then the university names listed.


After adding the question to your survey, you will see a page that looks like this. From here you can edit the instructions for the question as well as the list of answers. Enter the answer option for the primary text first, and the secondary answer option second, separated by a comma.

For example:
West,WA
West,OR
West,CA
Midwest,OH
Midwest,KY
Midwest,IN


This page simply shows how the dynamic lookup table will look in your survey. You will see the first drop down box with answer options, and after making a selection the next box will appear.


This shows how the second drop down box will appear in your survey.


Up until now we have been showing the drop down box for the dynamic lookup table. You also have the option to search by keyword. With this method, you can type a letter in the box to bring up options. Here we are showing that we typed a "W" in and brought up the answer options.


Lastly, we wanted to note that dynamic lookup tables are also supported on mobile. Add this question type to your survey online first, and then it can be easily used in the field via SurveyPocket or SurveySwipe. See the screenshots above to see what it looks like on mobile. We hope you have a better understanding of dynamic lookup tables now, and as always, feel free to reach out with any questions that you may have!

Comments

Post a Comment

Popular posts from this blog

Results of the Presidential Job Index Survey (week ending 7/1/2010)

Quick update on the results for the presidential job index survey for the week ending 7/1/2011. As a reminder this is a weekly survey that we conduct and we publish the results for the survey every Friday. To participate in this week's survey, please download the SurveySwipe application and take the survey.

Remember, you get points that you can redeem for various rewards when you take our surveys. We have already distributed several paid apps like Angry Birds for free.

Highlights

Almost 900 respondents took the survey.
52% vs 53% last week of the respondents approve of the job that President Obama is doing.
Respondents included 28% Democrats (31% last week), 25% Republicans (22% last week), 24% independents (27%) last week and 2% with the Green Party (3% last week).



You can view the reports here or directly on your phone.

Top 5 Infographics of the Week: Cyber Security

Earlier this week, we experienced a power outage with our data center at Internap. During this short period of time, our customers were unable to access the site. Luckily, it didn't last long and we are back up and running now thanks to our dedicated support team that responded quickly and worked diligently.

Cyber security is, and always has been, a very important issue for us as we continue to grow and meet the demands of a technology-driven society. Nothing is more paramount than the safety of your valuable data. And apparently we weren't the only ones affected, as LinkedIn was experiencing difficulties on the same day and Internap had 3 massive outages earlier this year. Check out these infographics with stats on the importance of cyber security and the impact it can have on small-medium sized businesses.

Top 5 Infographics of the Week: Internet of Things

In 2008, the number of things connected to the internet exceeded the number of people on Earth. By 2050, we are expected to surpass 50 million different devices connected to the internet. And we're not just talking smartphones and tablets - we mean everything. Wearable tech, household appliances, smart homes, public transportation, hospitals and even cattle have all been using sensors to transmit data automatically. It is an exciting yet scary time to be alive. The various interactions between these different entities are opening up doors for more apps, more software and more auxiliary services. With so many "things" connected online, the possibilities for information exchange becoming wider everyday. Check out the top 5 infographics to learn more about the IoT.