This page provides basic information on interpreting repeat data in form.

 

Overview

When you create a form export you have the option to include data that was captured in repeat groups. These are in a separate section of the export setup page, and you need to click on the checkbox to include this data in your export: 

After downloading the export you will see that the data for each type of repeat group is stored on a separate tab in your Excel file. A special column called row.number is used to link the repeat data with the main form submission. 

If you need to link the repeat data to a specific form submission you must include row.number in both the general form export and the repeat group export.

 

Using row.number

The row number will your key to determining which general form data is associated with a given row in the repeat data.

In the main form export you will see that row.number just contains an increment count (1, 2, 3, 4) with one unique number per row.

In the repeat group tab row.number will contain a number in the format:

x.y

So if you had 2 form submissions, and each time the repeat group was filled out twice you would expect to see the following:

Main Form Submission (first tab)

row.numberNote
0First Form
1Second Form

Repeat Data (second tab)

row.numberNote
0.0First repeat group from first form
0.1Second repeat group from first form
1.1First repeat group from second form
1.2Second repeat group from second form

 

You can use Excel functions like VLOOKUP to pull data from one tab to the other. For example, if you wanted to use a piece of data from the main form submission in a list of the repeat group data you could look up the row number from the first  tab and pull over the necessary info.

Nested Repeat Groups

If you have multiple repeat groups, nested one within the other, then you will notice that the row.number reference includes more levels. 

For example, if you a form with one repeat group (houses) and then another group within that (house members) you might see a row.number in this format for the house members repeat group tab:

x.y.z

By referring to these components you can find the different levels of relevant data.