...
Dates will be stored in the YYYY-MM-DD format and time values will all be converted to a canonical UTC timezone in the XML document. Date/Time values will be converted to the XML standard YYYY-MM-DDTHH:MM:SSZ.
| Note |
|---|
You will see the tie time values in the submission converted to UTC time if the value was entered by user into the form. You will see a UTC offset if the value was set by rule, _data or XML inititializationtime represented by the (Z) or the UTC offset. For example: 10:30 browser time EDT == is equal to 14:30Z or 10:30+4:00. Both are correctly formatted UTC values. The Z specifies UTC and the +4:00 is an example of the UTC offset. |
...
To get more information, double-click on the submission to view its details, and again hover over the icon.
If the mapped pdf has a you have a flow that has a mapped PDF with a severe mapping error such as (Invalid E-form field), the flow will submit and the pdf is generated. The submission is marked in error with a icon in the Submissons table. You will see the error: "One or more generated PDF forms generated with mapping errors. Some information may be missing." on the submission.
...
Submissions can be edited easily by clicking the form name rendered as a clickable URL on the clickable URL on the submissions. Only the designer user that created the form/flow can edit submissions. In this image below click on "Order" to edit the submission.
...
| Note |
|---|
If the current version of the form is different then when the data you're editing was originally submitted then some of the data may not be visible. For example if your form contained a field for "detailed description", and the current version of your form no longer has that field as the designer removed it, then the detailed description data will exist but will not be visible/editable. |
Previous releases of only allowed the form designer to edit the form in the ' submission UI page. Out of the box editable access to The designer can grant a non-designer can now be granted by the designer. See Access Control for the detailspermission to view submissions via the Access Control feature. It is also possible to build your own application that enables editable access to non-designers using the Data API.
Online users can edit submissions by default. The frevvo.submission.edit.link configuration configuration property can be modified in the <frevvo-home>/WEB-INF/web.xml file to disable/enable editing submissons for In-house users. The web.xml file must be unzipped from the frevvo.war before it can be edited. See Installation Tasks for the details.
...
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).
| 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.
...