| Section |
|---|
| Column |
|---|
comes with a built-in submissions repository. The repository can run on top of most SQL databases. By default, your form data is stored in the repository and can be viewed from the Submissions page. Filter your submissions using form data. Create Logical expressions to narrow the search for particular submissions. Fields in your form/workflow, set up as Searchable fields by the designer, can be used as criteria when searching submissions. Once your Searchable fields are defined, re-indexes existing submissions so you can search them using the same fields. Additional default fields such as: error, error description, submitter id, lock user id, started date, etc. can also be selected as filters. The Submissions view works well on mobile devices and is easily embedded in a web page and wikis such as Confluence. Customers running with Confluence will not see the legacy submissions view from the Confluence Screen. It is only available when you log into your Confluence tenant.
The Insight Server and the Insight service must be running for the Submission view to work. Cloud customers will see an icon for the Submission View and another icon for the Legacy submissions view. The Submission View Configuration Parameters topic discusses the ability to hide the Legacy view among other options for in-house customers. | Warning |
|---|
The Export of submissions to Excel feature has been replaced by the Download to CSV. If you have not used the Export to Excel feature in the past, we recommend that you become familiar with the Download to CSV . You can still use the Export to Excel feature by accessing it from the Submissions Legacy view. However, the Legacy Submissions view and the Export to Excel may be removed in a future release. |
The various items on the Submissions page are explained below. |
|
...
Even though the Data and Time fields are stored in the xml as shown above, when you export the submissions, Date,Time and Date/Time controls are displayed in UTC in the csv file and in Excel. Note the -05:00 indicates Eastern Standard Time while the -04:00 represents Daylight Savings Time.
Numbers or Text Controls with Leading Zeros
When you open a csv file in Excel, number or text control submissions that contain leading 0's will strip the leading zero. For example a zip code entered "06405",
Image Added
will appear in Excel as "6405".
Image Added
This happens because Excel makes assumptions about the way imported data should be formatted; usually leading zeros are mathematically insignificant, so they are removed. You can keep the leading zeros in CSV files by using Excel's Text Import Wizard. (These instructions may vary based on your Excel version.)
- Launch Excel Spreadsheet. Click the Data tab.
Click the From Text/CSV icon. Use the file manager to locate the CSV file you want import.
Click Import.
- Select Comma from the Delimiter dropdown.
Click Transform Data.
Select the column(s) that contains the data with leading zeros. Change the Data Type to "Text". The preview will refresh to show your data with leading zeros.
Image Added
Click Close & Load.
Submissions View on Mobile Devices
...