...
The Submissions table will show submissions in the following states: SUBMITTED, SAVED PENDING, ABORTED, ERROR and WAITING. Simply check the appropriate check box in the State section. When you click the Submissions 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:
- SAVED/PENDING: This will give you all the tasks which are saved or pending. This helps when you want to see all open tasks for a certain form/flow
- SAVED: This will return only those tasks which were created when users clicked the Save button on the form/flow to save their partially filled forms
- PENDING: This will return all tasks which are pending, meaning someone else put these tasks in the users task list
- SUBMITTED: This will return all tasks which are completed, i.e. the form/flow for which this task was created has been submitted
- ABORTED: This will return all the tasks that were deleted/aborted so the form/flow never got submitted
- WAITING: The WAITING status can be used to find workflow tasks that have an Email or HTTP activity. A submission will show a state of WAITING when a workflow is routed to an anonymous user and the flow is suspended until the this step is completed.
| Note |
|---|
It would be easy for a manager to check the current status of Expense Report approvals by checking one or all |
...
| Note |
|---|
A submission will show a state of WAITING when a workflow is routed to an anonymous user and the flow is suspended until the this step is completedthe submission types in the State box. |
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.
...
| Field | Formatted | Default Column | Description |
|---|---|---|---|
| Submitted | Date/time | Yes | Time/date of the submission |
| State | Text | Yes | Submission status: SUBMITTED, PENDING, ABORTED, SAVED, ERROR WAITING. This column displays the submission types selected in the State |
| Age/Duration | Days, Hours, Minutes | Yes | For completed submissions (State=Submitted) this is the time interval for how long it was in process - from the first incomplete submission (Pending, saved, etc.) until it reached SUBMITTED status. was in process - from the first incomplete submission (Pending, saved, etc.) until it reached SUBMITTED status. If the submission is currently incomplete (i.e. SAVED, PENDING or WAITING), then the time interval shows how long has it been in process so far (Age). |
| Lock User | Text | Yes | If the submission is currently locked (and not SUBMITTED), this is the user id who has it locked. |
| Lock Date | Date/Time | Yes | If the submission is currently incomplete (i.e. SAVED, PENDING or WAITING), then the time interval shows how long has it been in process so far (Age). |
| Lock User | Text | Yes | If the submission is currently locked (and not SUBMITTED), this is the user id who has it locked. |
| Lock Date | Date/Time | Yes | If the submission is currently locked (and not SUBMITTED), this is the time/date when it was locked.locked (and not SUBMITTED), this is the time/date when it was locked. |
The submitter is the Live Forms 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 increments the version each time you revise your form.)
A 
yellow icon in the Err column indicates the data was captured but there was an issue with the request. For example, if you set the form action property to go to a URL after the user clicks Submit but the URL is invalid, you would see a yellow icon. Or if the form action was set to send an email but the email address was missing, this will also cause a yellow icon to appear on the submission.
...
When you click the Submissions icon, only submissions with a status you will see submissions that are in the default state of SUBMITTED display. Notice the View/Edit and Delete a single submission are greyed out. Checking the checkbox preceding the submission in the table enables these buttons.
To view a particular submission results document, double click the submission row of interest in the table or if viewing/editing submissoins on a moblie device, check the checkbox preceding the submission and click on the enabled View/Edit icon. View/Edit icon. The image shows the submission table on the iPhone:
You will see a Data, Signature and Document Tab. Click X to exit the form.
...
Click the Excel 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. Hide the columns in Excel if you do not want to display them in your spreadsheet.
| Info |
|---|
Selecting the Excel export feature when viewing submissions from the Shared Items tab (inside or outside of a space) on an IOS device (iPad,iPhone), may have to install an application to edit and save .xls files. This requirement is browser specific. |
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.
...
Processing submission data using the frevvo API
provides a complete RESTful 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.
...