With the Excel & Excel Flat Views, you have the ability to display all collected user data in a table format via a downloadable Excel spreadsheet. The View will display the form labels and filters can be applied to data once in the Excel application.
Wondering what the difference is between the Excel & Excel Flat Views? The difference between the Excel & Excel Flat View is how the Multi-Paging Subform data is displayed.
* The following article will use the same form data to show how Single Paging Record Data is displayed and the difference of Multiple Paging Records in Excel and Excel Flat Views.
Whether it be a form without any subforms, a parent form or a Single Link Subform (user can only complete one record for the subform)- each records data will appear on it's own line. Subforms each have their own tab and all data for the subform record can be found there.
Select the Form you want to view (A) and click Excel or Excel Flat (B).
Single Records are all viewed on their own line. This is the example of the parent form.
In the Excel View, a Multi-Paging Subform allows a user to complete the subform more than once while still in the parent form. Here, each record that a user completes will be viewed on a separate line of the subform records.
Excel Flat View is used when you have multiple records collected in a multi-paging subform element. The Subform records will appear in one of the tabs on the sheet and the multi-paging subform records will be on the same row instead of being stacked like in the Excel View.
Select the Form you want to view (A) and click Excel Flat (B).