...
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.
Other important details about the graph:
...
- 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 the submission types in the State box. |
| Note |
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 displays columns for submission time/date, state, Age/Duration, Lock User and Lock Date. These columns are explained in the table below:
| 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. 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 ID | 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. |
...
If you want to see when the submission was created, add the Started column to the table.
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.
...
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).
.png?version=1&modificationDate=1443902544000&cacheVersion=1&api=v2&width=500)
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.
| 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.
...