FAQ content

Submission Reports: View, manage, and analyze a report's submission data

In this article

View and manage submissions

The Data Table tab of a report allows you to view all of the submissions that have been made. From here you can filter the report to narrow the results displayed, navigate (and export) the submissions, preview submissions, edit submissions (forms and surveys only), or delete unneeded submissions.

Advanced filters

When viewing the report for a form, survey, quiz, or tutorial, you can filter the submission data by submission date and field values. These filters will be reflected in the Data Table, Field Analysis, and Cross Tab reports, as well as any data you export while the filter is applied.

To get started, click on the Advanced Filters panel at the top of the Reports page to expand it.

The expanded Advanced Filters panel
Filter by field
  1. Create your filter under Available Filter Options.
    1. From the first dropdown, select the field you want to filter by.
    2. From the second dropdown, select the logic for your comparison. For example, if you select "Equals", the field will need to equal a specific value in order to appear in the Data Table.
    3. From the third dropdown, select or enter the value to compare against the field's response.
  2. Click the Add Filter button. Each filter you add will appear under the Current Filters list.
Adding a field filter
Filter by submission date
  1. Use the Submitted From field to enter or select the earliest submission date you want to view. Records submitted before this date will be excluded from the Data Table.
  2. Use the Submitted To field to enter or select the last submission date you want to view. Records submitted after this date will be excluded from the Data Table.
Filtering by submission date
Max submissions to retrieve

When there are more than 1,000 submissions an additional Max Submissions to Retrieve filter will be visible. This filter can be used to indicate the maximum number of submissions to display in the report. 

This filter will default to returning 1,000 submissions but can be adjusted to return up to the total number of submissions made.

Filtering by max submissions returned
Matching logic

When using a combination of filters, you can choose to use either OR or AND logic. 

  1. Click on the Current Filters dropdown and select your matching option.
    • Select Match all below if you only want to view records that match all of your current filters (AND logic).
    • Select Match any below to view records that match at least one of your current filters (OR logic).
Selecting the matching logic for filters
Removing filters
  1. Under Current Filters, click on the Delete () icon for the filter you want to remove.
Removing a filter

  1. Use the Live and Preview buttons to toggle between submissions from your live form and those made while in Preview Mode.
  2. Use the Search submissions by keyword or ID field to narrow the data table to records containing your search string or by the ID of an individual submission.
  3. Use the pagination controls to increase or decrease the number of records per page, and navigate between pages of records.
  4. Click on any column heading to sort the Data Table by that field. Click it again to switch between ascending and descending sort order.
  5. Click on the Export CSV button to download a CSV file.
    • The export file will contain all records in the Data Table. So, if you applied any filters to your data, only the filtered results will be exported.
    • The CSV file will include all columns, even ones that are not currently displayed in the Data Table report.
  6. Click on the Displayed Columns button to choose what columns to show.
    • From the dropdown menu, use the checkboxes to toggle each field's visibility. Fields without a checkmark will not display on the page.
  7. Click on the Statistics button to view the overall grade statistics for all submissions.
    • This gives you information on the average and median overall scores (along with the standard deviation), as well as the percentage of correct responses for each individual question.
    • Statistics are only available for quizzes and tutorials.
  8. Click the Refresh button to refresh the Data Table. This can be helpful if you want to check for newly submitted records without reloading the entire page.
Searching and sorting a data table

Preview an individual submission

To preview an individual submission:

  1. View the report for your form, survey, quiz, or tutorial.
    1. Use the Live and Preview buttons to toggle between submissions from your live form and those made while in Preview Mode.
Clicking the View Submission icon
  1. Under the Data Table tab, click on the View Submission () icon for the submission you want to view. A window will appear containing that submission's data, along the user's IP address, browser, and referrer (if enabled in your form, survey, quiz, or tutorial's Reporting settings.).
    1. To return to the Data Table, click the Close button.
    2. If you'd like to print a copy of this record, click on the Print button.
    3. If this is a graded quiz or tutorial, correct responses will have green text, while incorrect responses will have red text. If a question was not graded, it will appear in black text.
    4. For each graded question, you will also see the overall percentage of correct responses.
Viewing a form or survey submission
Example of a quiz submission

Edit a submission (forms & surveys only)

A form or survey's owner, as well as Admin users, has the ability to edit any of its submissions. If the form/survey's status is Public, other Regular users can only preview submissions -- not edit them.

Please note, quiz and tutorial submissions can not be edited.

  1. View your form or survey's report and, under the Data Table tab, click on the Edit () icon for the submission you want to modify.
    1. Use the Live and Preview buttons to toggle between submissions from your live form and those made while in Preview Mode.
Clicking the Edit icon
  1. You will be taken to an "Edit" version of the live form, with the submission data listed in each field.
    1. This view will display hidden fields on screen, allowing you to edit them as well. Each hidden field will display inside of an orange container with a Hidden () icon below it.
  2. Make your changes to the form and click the Edit button to save them.
A submission's Edit Mode page

Delete a submission

A form, survey, quiz, or tutorial's owner, as well as Admin users, have the ability to delete any of its submissions. If its status is Public, other Regular users can only preview submissions -- not delete them.

  1. View your form, survey, quiz, or tutorial's report and, under the Data Table tab, click on the Delete () icon for the submission you want to delete.
    1. Use the Live and Preview buttons to toggle between submissions from your live form and those made while in Preview Mode.
Deleting a form submission

[Return to top]


Generate a field analysis report

The Field Analysis report provides a breakdown of responses by field, for the following field types:

  • Dropdown
  • Radio
  • Checkbox
  • Rating
  • Grid
  • Ranking
  • Image choice

This is an easy way to compare the distribution of responses for those fields. Each field analysis can be displayed in a chart, or as a data table.

To generate a field analysis:

  1. View your submission report.
  2. Click on the Field Analysis tab.
  3. In the first dropdown, select the field you want to analyze.
  4. Click the Report button.
    1. Use the Chart Type dropdown to switch between a column chart, bar chart, pie chart, or data table view.
    2. Click on the Chart Context Menu () to print or export a chart.

The Field Analysis report will include all records displaying in the Data Table report. So, if you applied any filters, only those filtered records will be reflected in the analysis.

Example of a Field Analysis report

[Return to top]


Generate a cross tab report

The Cross Tab report allows you to compare the responses between two fields of the following types:

  • Dropdown
  • Radio
  • Checkbox
  • Rating

This is an easy way to see the relationship between two fields. Each field analysis is displayed in a chart, as well as a data table.

To generate a cross tab report:

  1. View your form's reports.
  2. Click on the Cross Tab tab.
  3. In the first dropdown, select the first field you want to analyze. This will display as the heading of each row.
  4. In the second dropdown, select the second field you want to analyze. This will display as the heading of each column.
  5. Choose the Chart Type to switch between column, bar, or stack charts.
  6. Click the Report button.
    1. Click on the Chart Context Menu () to print or export a chart.

The Cross Tab report will include all records displaying in the Data Table report. So, if you applied any filters, only those filtered records will be reflected in the analysis.

Example of a Cross Tab report

[Return to top]