Thanks for taking the time to talk with us.
Before we start talking, please enter your name and email address below.
Multiple pages have two records instead of one in the captured data. The first record has half the data and the second record has the other half. What did I do wrong and how to I get the pages into one record?
The reason you get two records is because you published the form as a "Key field reconciles" publication, and you don't have a Key Field (a bubble grid or a barcode reader area) on BOTH pages.
The key field will tie the two pages together into the one record. If you don't do that it will think each page is a different form.
How to fix:
Rather than publishing the forms as key field reconciles, publish the form as a unique form using Form ID. To do this, create a source data table and add the field name "form_number". Then go to Excel, add the heading form_number to the first row, click on the next row and enter the number 1. Click on the cell that contains 1 then hold the shift key and use the arrow keys to go down the page to the number of forms you'd like to create. Click Edit -> Fill Series and Excel should populate the column with numbers sequentially from 1 to the number of rows you have selected. Save this file as a CSV file. Open up FormReturn and click source data. Select the new table and click import records. Select the CSV file and import the data from it.
On each page you could also add «form_number» as a text area to help you know which pages belong together (in the event of them getting mixed up). The downside of doing this is that you'd have to print out a big PDF file (which may not be practical if you are doing a few thousand or more pages).