Submission Data

Submission From Date and To Date

The two date controls specify the time period for the submissions you see. The dates default to the current date and one month earlier, so you see one month of submission results when the Submissions page first displays.  Adjust the dates if you want a shorter or longer time period. 

Submissions Graph

The graph shows you how many submissions you’ve received over a given time period. The green bars provide a breakdown of exactly when you received the submissions. Hover over any green bar to display a tooltip submission count. Forms/flows that have been submitted display by default when you first click on the Submissions icon. If you select additional submission states from the State checkbox on the left, the graph will adjust based on your choices.

...

• The graph reflects the time period you see in the two date controls based on the options checked in the State checkbox.
• The time increments along the bottom are calculated automatically to make sense for the time period you view--seven days for the weekly view, for example.
• The green bars (period) reflect the number of submissions in a given period.
• The <<day>>, <<week>>, <<month>> or <<year>> links above the graph are shortcuts to quickly change the date range. The graph will show you the most recent period—for example, if you click <<week>>, you’ll see a week’s worth of submissions, starting from a week ago up to the current date. The dates you see in the To Date and From Date controls also will be adjusted automatically.
• The unlabeled << link to the far left moves the date range back. The exact behavior depends on the dates in the date controls before you click the link. If the date range is May 11th to May 15th, for example, clicking the << link will move the range back to May 7th to May 11th. Similarly, clicking the >> link slides the date range forward.

Submissions Table

The Submissions table will show submissions in the following states: SUBMITTED, SAVED  SAVED, PENDING, ERROR, ABORTED, ERROR and WAITING. Simply check the appropriate check box in the State section. When you click the Image Removed Submissions the Image Added Submissions (legacy) icon, you will see SUBMITTED items by default. You must choose at least one state or you will see the message "Please select to/from dates and at least one state".

Here is an explanation of the available states:

1. SAVED/PENDINGSUBMITTED: This will give you return all the tasks which are saved or pending. This helps when you want to see all open tasks for a certain form/flowcompleted, i.e. the form/workflow for which this task was created has been submitted
2. SAVED: This will return only those tasks which were created when users clicked the Save button on the form/flow workflow to save their partially filled forms
3. PENDING: This will return all tasks which are pending, meaning someone else put these tasks in the users task list
4. SUBMITTEDERROR: This will return all tasks which are completed, i.e. the form/flow for which this task was created has been submittedthat are in an error state.
5. ABORTED: This will return all the tasks that were deleted/aborted so the form/flow workflow never got submitted
6. WAITING: The WAITING status can be used to find workflow tasks that have an Email or HTTP activity. A  A submission will show a state of WAITING  when a workflow is routed to an anonymous user and the flow workflow is suspended until the this step is completed.

...

By default the submission table displays columns for submission time/date, state, Age/Duration, Lock User and Lock Date. These columns are explained in the table below:

The submitter is the Live Forms 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 Live Forms frevvo increments the version each time you revise your form.)

...

When viewing Pending tasks, you can see the First and Last name of the user who has the task locked and the ID and name of the submitter by adding theLock User name, Submitter ID and Submitter Name columns to the Submission table.

Submissions Detail

When you click the Submissions icon, you will see submissions that are in the default state of SUBMITTED. Notice the View/Edit and Delete a single submission are greyed out. Checking the checkbox preceding the submission in the table enables these buttons.

...

• 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 displays only form fields setup as saved fields in the form designer. If you do not see a specific form field then go back and edit this form to add the field to the saved fields.
• The Signature Tab shows you all the users that signed the form using ' wet and digital signature features.
• The Documents Tab shows you the exact XML document that was generated when the form was submitted.

Viewing Attachments & PDF Images

Scroll to the bottom of the Data Tab to see all attachments uploaded to the form submission. If you selected Save PDF for this form in the form designer, you will also see an attachment named <form name>.pdf. This is an image of your form exactly how the user saw it when they filled it in and submitted it to you. Remember, decorators and placeholders do not appear in PDF's. The image below also shows W4-pdf and I-9.pdf attachments. These are additional Pixel Perfect PDFs generated for the Employee's Withholding Allowance Certificate and the Employment Eligibility Verification federal forms. Click the links on the Data Tab to view the PDFs or attachments.

...

One of the attachments is a Wet Signature image. Clicking on the Signature tab lists the manager, Jerry's digital signture and the and wet signature image of the new employee. The signature image can be downloaded from the Data or Signature tabs of the form submission. There you will find information about any digital signatures that were stored with the form. See Electronic Signatures for more information.

...

You can specify the name for the pdf and margins, header/footer content. Click the links for the details.

Viewing XML Documents

 always stores your form data as XML documents. To view the XML data, click the Documents tab in the Submission Details panel.

...

Dates will be stored in the YYYY-MM-DD format. There is no conversion to UTC timezones for the time control in the XML document. Date/Time values will be converted to the XML standard YYYY-MM-DDTHH:MM:SSZ. 

Submission Errors

If your submission had an error, you'll see an icon  in the Err column in the submissions list. Hover over the icon to get information about the error.

...

Once the Insight server is restarted and the Refresh Searchable Fields process is run, the submissions will show in the Recent Submissions report.

Editing Submissions

Only submissions in the SUBMITTED state can be edited. If you have the correct permissions, submissions can be edited easily by clicking the form name rendered as a clickable URL on the submission. In this image below click on "Product Order Form" to edit the submission.

...

 Online users can edit submissions by default. The edit link can be turned off for all users by modifying the frevvo.submission.edit.link configuration property in the <frevvo-home>/WEB-INF/web.xml or the <frevvo-home>/tomcat/conf/catalina/localhost/frevvo.xml files for  In-house customers. 

Instantiate Older Submissions

Form/flow submissions are grouped by formid and uniquely identified by a submission id. Normally,  allows you to instantiate from submission using the formtype or flowtype uri and the _submission parameter. The supplied _submission parameter value corresponds to the latest submission for that formid. If you are instantiating an older submission id, you see the following message: "Access Denied. This submission has already been processed".

The URL parameter (_override=true) allows the re-instantiation to happen even if the _submission does not correspond to the latest for the formid sequence. If you want users to see and potentially re-submit older versions, you will must append the _override=true parameter to the form/flow share link.

Let's say you want your non-designer users to be able to resubmit older versions of a form/flow. For example, imagine populating this year's Budget form with the information from the Budget form that was submitted last year. Now all you have to do is update the information for the current year instead of filling in the form again.

1. The designer must grant view/edit permissions to the non-designer users via the Access Control feature. 

2. Append the _submission id paramater with the submission id and the override=true parameter to the form/flow share URL.  The designer user can locate the submission id by adding the submission - id column to the submissions table. 

Image Removed

       3. Copy the form/flow URL and append _submission=<ID ENTRY FROM FORM SUBMISSION TABLE>  - Here is an example of the Product Order Form with the submission id, d310878f-94cc-41f6-ad4c-dd864b4fd513, which references an older submission.  

http://localhost:8082/frevvo/web/tn/doctenant/user/designer/app/_zQEN0Cx9EeSLmcVfjx9TOA/formtype/_QG3AIAxXEeSQ9sn0Gh0q3A/popupform?_submission=d310878f-94cc-41f6-ad4c-dd864b4fd513

4. Without the _override=true parameter appended to the URL, the "Access Denied. This submission has already been processed" message will display.

5. To access this submission, append the _override=true to the form/flow share url:

http://localhost:8082/frevvo/web/tn/doctenant/user/designer/app/_zQEN0Cx9EeSLmcVfjx9TOA/formtype/_QG3AIAxXEeSQ9sn0Gh0q3A/popupform?_submission=d310878f-94cc-41f6-ad4c-dd864b4fd513&_override=true

        6. The values displayed are from an older submission of the Product Order Form.

Image Removed

/tomcat/conf/catalina/localhost/frevvo.xml files for  In-house customers. 

Sorting Submission Results

When you mouse over a column in the Submission area you’ll see the  icon. Click it and choose from several sorting and grouping options:   

...

Deleting Submissions

When you click the Submissions icon, only submissions with a status of SUBMITTED display. Notice the View/Edit and Delete a single submission icons are greyed out and the Delete All icon is enabled. When clicked, the delete all action will only delete SUBMITTED items. You will be asked to confirm.

...

To delete a single submission, check the checkbox preceding the submission in the table. Notice the  View/Edit and Delete a single submission icons become enabled. This will only be enabled when a SUBMITTED submission is selected. You will be asked to confirm.

Viewing Submissions in Excel

...

Click the  icon at the top of the table to view the submission results in Excel. The spreadsheet reflects the submissions that are displayed in the table (filtered by date and submission type). 

The default columns in the submission table appear in the spreadsheet even if you are not displaying them in the table. Default columns for Lock User Name, Submitted By ID and Submitted By Name have been added/renamed to display that information if it is included in your submissions. Hide the columns in Excel if you do not want to display them in your spreadsheet.

...

Repeating Data

Forms containing repeat controls will generate multiple rows in the exported Excel worksheet for each form submission -- one row for the submissions itself plus one row for each repeat item added and filled on the form. The Excel workbook groups the data for each submissions. Thus initially it may appear that there is only a single row of data in your workbook with a "..." displayed for the repeating item. Simply click the "+" in the far left-hand side of each row to expand the group and view all your repeating data.

...

Columns added to the Submission Table will not show in the Excel spreadsheet. See Submissions Stored Inside of Live Forms - Legacy View Submission Table for information about how to add a column. For Example, adding the form ID column to the Submission Table will not put a Form ID column in the Excel spreadsheet. This is as designed.

...

Time and date time values exported to Excel are submitted UTC values from the submission doc. Time data will be displayed in the Excel spreadsheet in UTC format.  For Example: The Product Order Spreadsheet shows the data from two customer orders entered at 9:00 AM and 2:30 PM in the Eastern Standard Time Zone. Time data will be converted to UTC and stored in the xml document. Exporting the submissions data to Excel will show the time data converted to UTC as it is in the xml document. See the Order Time column in the image.

Processing submission data using the frevvo API

 provides a complete API for interacting with the system. Using the API, you can query submissions, download submission PDF/XML etc. Using the API is documented in its own Tutorial.

...