Lists

This section is necessary because some questions require items from a list. For example, imagine you want to ask a user which territory (from 40 possible territories) they manage, and then in a later question, ask which city within that territory they saw something. This creates a one-to-many relationship: the user manages one territory, and that territory contains multiple cities.

To manage lists, go to the Lists menu option. The following functionalities are available:

  1. Upload a list through an Excel file. This list can be a parent list or a child list.
  2. Edit, delete, and view lists.

Example:

Parent list: - Territory - Option 1 -- Alpujarra Occidental - Option 2 -- Axarquia - Option 3 -- Donana

Child List: (Associated with a parent list. In this example, places are associated with territories; the child items are highlighted below.) - Territory - Option 1 -- Alpujarra Occidental - Ferreira - Lanteira - Orgiva - Nevada - Option 2 -- Axarquia - Alhama de Granada - Otivar - Periana - Velez-Malaga

Excel format:

For parent lists: - First row is the header: id, Item name - Subsequent rows contain the data.

For child lists: - First row is the header: idUser, Item name, id of parent item - Subsequent rows contain the data.

The third column links a child item to its parent. For example, "Abalario" has three associated "Poblacion" entries: Aznalcazar, Lebrija, and Puebla del Rio.