Saved fields are only used for the Export of submissions to Excel which is currently available from the Legacy Submissions view. However, the Legacy Submission View and the submissions Export to Excel will be removed in the next major release. The submissions Export to Excel feature has been replaced by the Download Submissions to CSV feature.
Submission Download to CSV file feature
The submissions to Excel export has been replaced by the Submissions Download to CSV (comma separated values) feature. The csv file is easily opened in Excel. Customers currently using the Export to Excel feature can still access it by clicking on the Submissions(legacy) icon.
The contents of the csv file depends on the submission columns that are displayed in the Submissions Table. The default columns and any form fields designated as Searchable fields appear as columns from left to right in the csv file.
The Legacy Submission View and the submissions Export to Excel will be removed in the next major release. The submissions Export to Excel feature has been replaced by the Download Submissions to CSV feature. Please begin using the redesigned submission view as soon as possible.
Forms/flows containing repeat controls will generate comma separated data in a single row in the downloaded csv file.
Consider an Airline reservation form where the number of traveler information sections displayed or the number of rows in a table is based on the number of airline tickets purchased. A section named Travel Information inside of a Repeat is designed to collect information about each traveler. Travel No, First Name and Last Name are set up in the form as Searchable fields.
Changing the Column Order in the CSV file.
To change the order of the columns created from the Searchable fields in your form/flows:
- Change the order on the Searchable fields tab using the setup wizard
- Create a new submission to reflect the new column order in the Submissions Table..
- The csv file will reflect the new column order.
Search the Task List using Form/Flow fields