...
- 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.
...
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.
...