Versions Compared

Key

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

...

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.

Image Added
 

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

Image Added

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

Image Added

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.

...