I am accepting registrations for multiple players to sign up for a soccer program. The repeating section allows the registrant to sign up multiple players by the "Add a Player" function. However, when I export the entries, it does not include the information in the repeating sections, which is frankly all that I care about. How do I get around this?
Cognito-forms – Cognito Forms: Why Doesn’t an Export show Repeating Sections
cognito-forms
Related Solutions
I am a developer for Cognito Forms.
Cognito Forms supports repeating sections to capture repeating data. It also supports exporting entry data to an Excel spreadsheet with one sheet containing the main entry data and additional sheets for each repeating section. CSV export is not currently supported due to the requirement of exporting hierarchical data like this.
Anyone can sign up for free and create an organization account, but currently this is limited to one organization per user and one user per organization. This limitation will disappear in the coming months as new features are added.
There are a couple of ways to handle calculating subtotals for repeating sections:
- If the form represents a true invoice and the subtotals represent money and nothing else, you can set the form up to use the built in payment features of Cognito Forms. When you mark fields as Collect Payment, they will automatically appear on receipt/invoice grouped by repeating section item. Choice, Currency, Yes/No and Price fields can all appear on this "invoice" and the Price field gives you complete control with the ability to calculate both the amounts and the description of each line item if you need this power. In this case you would not be collecting payment from them, so mark the form via Payment Settings as never requiring payment.
- The other option is to use the powerful calculation capabilities in Cognito Forms to quickly calculate the subtotals. In the example above, you could add a Calculation field at the bottom of the form and use a calculation like
=MyOrder.Sum(ItemTotal)or even=MyOrder.Sum(Product_Amount * Quantity)to calculate the total for the My Order repeating section. Remember set the Type to Currency for the Calculation field so it will be formatted correctly and allow you to use the value of this field in other calculations. You can learn more about these capabilities in our help documentation at: https://www.cognitoforms.com/support/51/calculations/repeating-sectionstables. Take a look at the section on Working with Repeating Sections.
Please mark this as the answer if it helps you make this work, or add a comment if it is not quite what you were looking for.
Best Answer
Repeating sections in Cognito Forms are exported as separate sheets that link back to the parent sheet. This allows you to have multiple repeating sections on the same form.