Submissions

Submissions are the values that were submitted to the form you built. These can be thought of as “objects” within the system and operate very much like them. You can get to an administrative view of submissions by clicking the Data tab on the navigation bar. Here you can see a graph which displays submission requests by year, month, or day.

1 data tab

You can access submissions by clicking the data button next to the desired Form or Resource, or utilize the Export button to export CSV or JSON files for the submissions. You can also embed submissions directly using a <formio> Angular directive or you can query the API directly. See Application Embedding and Developer API for more information.

2 data export

Viewing Submissions

Think of the submissions view as administrative access to the database. This should not be used for typical interaction with the application and is not designed for end user use.

The Submissions page gives you an administrative overview of submissions to your forms.

You can see a table view of the fields that had “Table view” selected on them. To add or remove fields from this display, edit the field on the Form Edit page and uncheck “Table View”

From the Submissions overview page you can also view, edit and delete individual submissions to your forms. Use the icons on the right to perform these actions.

Exporting Submissions

Use the two buttons at the top of the submissions list to export all of your data for a form. These operations are streamed from the database which means they should start very quickly and will work on very large datasets without having to write everything out to the server before starting the download.

Export JSON

JSON is Javascript Object Notation and is a way of representing data in a common way for javascript applications. Many other programming languages are able to read in JSON as well. Since data in Form.io is stored in JSON format, this will be the truest form of the data.

Export CSV

CSV is Comma Separated Values and data is squashed down to rows of values with commas between them. This may not work well for complex data structures as it is essentially a flat file. CSV files can be opened by spreadsheet applications like Excel.