Day 23: Menu Lookups
Previous Topic  Next Topic 

In the last lesson we asked you to use the LOOKUP question allowing you to define your own lookup tables from scratch. If you have not done that, go back and do it now before continuing with this lesson.

This lesson will show you how to use lookup tables to create menus within your survey.


Now do the following.

    1. Open the survey you created on Day 22 of this tutorial 'Day 22'. Create a copy of the survey under a different name. Name the survey 'Day 23'.

    1. Today’s lesson will continue to explore the uses of lookup tables when designing your surveys. On ‘Day 22’ you learnt how to create a menu lookup question by using a menu variable and lookup type question. Delete the questions ‘Lookup Wine Countries’, ‘Wine Country’, ‘Lookup Wine Type’ and ‘Wine Type’ from your survey. There is a much simpler and recommended method in creating menu lookups using only one question.

    1. After the question ‘Do you like wine?’ create a MENU question with the name “Wine Country”. Click LOOKUP in the LIST TYPE menu. Select the TABLE ‘Wine’ and the MENU ‘Wine Country’. Make sure ‘Wine Country’ is selected from the USE menu at the bottom left of the question definition dialog. INSERT the question.

    1. Create a MENU question with a question prompt of “Favourite wine from {{Wine Country}}”. Give this question a DATA NAME of “Favourite Wine”. Select ‘Wine Type’ from the MENU and USE lists and MATCH ‘Wine Country’ WITH ‘Wine Country’. INSERT the question.

    1. Now amend the MESSAGE question so that it reads:

“You prefer a Red {{Favourite Wine}} from {{Wine Country}}. This wine should be served at {{Serving Temperature}}*C.”

    1. SAVE and RUN your survey. You should see the survey runs similarly to the survey you created on ‘Day 22’.

The next lesson will show you how to create and save multiple items within PocketSurvey, and how to view your data in the PS DATA MANAGER.

Final Tip

Menu lookups are particularly useful in surveys that require the menu questions to be repeatedly asked. E.g. a location menu question for a housing survey. Menu lookups avoid duplicate questions being created.

HandHeld Systems Ltd ©