Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 Image Removed Submissions iconthe Image Added View Submissions (legacy), 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".

...

Submissions Detail

When you click the Image Removed Submissions the  Image Added View Submissions (legacy) 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.

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 Image Removed View/Edit icon Image Added View Submissions (legacy) icon. The image shows the submission table on the iPhone:

...

Deleting Submissions

When you click the Image Removed Submissions iconthe  Image Added View Submissions (legacy) icon, only submissions with a status of SUBMITTED display. Notice the View/Edit and Delete a single submission icons are greyed out and the Delete All icon is enabled. When clicked, the delete all action will only delete SUBMITTED items. You will be asked to confirm.

...

Expand
titleClick here for information about Saved/Key fields

Saved Fields

Saved Fields are stored in the database when the form/workflow is completed. The fields you select will be displayed in the Submission Detail for each submission. You can also search the submissions repository for these fields using the  API.

On the Form/workflow properties panel, click the Setup Key/Saved fields link to open the wizard.

Let's say you set up the Saved Fields in a Product Order Formas shown below:

Image Removed

.

When you click the Excel icon to export the submissions data to an Excel Spreadsheet, you will be given the option to open or save the file. The file will be named using the range of dates of the Submission data, if you choose to save it to disk . For Example, you might have submission data from February 15th to March 15th of the year 2013 that you want to export. The file name would be something like Submissions%28021513-031513%29(1).xls. Opening the file will show the tenant and project name, the date range of the submission data and the number of submissions. The portion of the Excel Spreadsheet shown in the image is an example of a modified output file.


Perhaps, as the form designer, you decide that the Phone column should be between the Color and the Email Address columns. You can change the order of the columns using the arrows or drag and drop to this:
Image Removedthem.

Exporting the submission results to Excel will arrange the columns in the spreadsheet as shown:
Image Removedyou designed.

Note

When you first open the Excel spreadsheet, the submissions meta data (Started Date, Updated Date, State, Age/Duration, Lock User, Lock Date, Revision, Status, Submitted By and Submitted IP) makes up the first 11 columns. You cannot reorder the meta data columns.


Image Removedv613SpreadsheetswithMetaData.PNGImage Added

Fields saved as part of a submission are always included in the export. For example, suppose several submissions of the Product Order Form were created with the Saved Fields list shown in the image:
Image RemovedSavedFieldsforRemovalExample.pngImage Added

The designer then removes the Phone field from the Saved Fields list. Exporting the previous created submissions after the change, will order the saved fields by the new list. Previously saved fields which are present in the submission but not in the current list are added on as the right-most columns of the spreadsheet.
Image Removed
Image Added

Key Fields 

Click the Key Fields tab. Up to five key fields may be efficiently stored along with the form submission. Key fields do not significantly reduce performance nor do they consume significant additional storage in the repository. It is also very efficient to search the submissions repository using these key fields. Key fields are also directly displayed in the Submissions Table so you can easily view them in a tabular view.
Image Removed
Image Added

Multiple Controls with Same Name

It is possible that your form contains two or more controls with the same name nested inside different sections. For example if your form has a section control named Parent containing a text control called Name and has another section control named Child also containing a text control called Name, the Key/Saved Fields wizard will display two entries called "Name". In order to to know which is which, simply hover your mouse over each entry in the list for Saved Fields or dropdown for Key Fields and you will see the path to the control. In the example below you see Parent > Child > Name.
Image Removed
v53keySavedHover.pngImage Added

The same name fields will be categorized in the data tab of the form submission like this:
Image Removed
v53SameFieldNameParentChildDataTabSubmissions.pngImage Added

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

...