The submissions repository can store your form data in three ways -- as data values; as an [[#XML_Document | xml document]]; as a [[#Viewing_Attachments_.26_PDF_Image | pdf form image]]. By default for efficiency, data is only stored as xml. If you plan to [[#Viewing_Submissions_in_Excel | export your form data to an Excel spreadsheet]] or plan to view your form data in the [[#Submissions_Detail | submission detail view]] you must configure your form to save the data field values. See the documentation for [[V4_Designing_Forms#Setup_Key.2FSaved_Fields | setting up key/saved fields]].
The Submissions table at the bottom of the page lets you see the key field values for each submission in the selected date range. The table displays the most recent 20 submissions in the selected range. Use the scroll controls at the bottom of the table to see the next 20 submissions or to jump to the first of last batch of 20 in the selected date range.
By default the submission table also displays columns for status, submission date, submitter name and form version. The submitter name is the frevvo user ID of the logged in tenant user submitting the form or blank if the form was submitted by an anonymous user. The version tells you how many times you have edited the form. This is helpful if you have updated your form and need to track how many users submitted the newest version. (When you create a form the version number starts at 1 but frevvo increments the version each time you revise your form.)
You can show or hide additional default column data by hovering over any column header and clicking the dropdown arrow that appears.
To view a particular submission results document, double click the submission row of interest in the table. You will see a Data, Signature and Document Tab. Click X to exit the form.
- The Data Tab shows the user’s view of the data. This means for money controls you’ll see dollar signs, decimals and commas, for example. The Label column corresponds to the labels on your form, and the Value column shows you what the user entered in each control. This tab is view-only; you cannot edit any data shown here. This tab display only form fields setup as [[V4_Designing_Forms#Setup_Key.2FSaved_Fields | saved fields]] in the form designer. If you do not see a specific form field then go back and edit this form to added the field to the [[V4_Designing_Forms#Setup_Key.2FSaved_Fields | saved fields]].
- The Signature Tab shows you all the users that signed the form using frevvo's digital signature feature.
- The Documents Tab shows you the exact XML document that was generated when the form was submitted.
Viewing Attachments & PDF Image
frevvo always stores your form data as XML documents. To view the XML data, click the Documents tab in the Submission Details panel.
If your submission had an error, you'll see an icon [[Image:error.png]] in the ''Err'' column in the submissions list. Hover over the icon to get information about the error.