Page Comparison

...

The Field column includes a dropdown where you can select any fields that were specified in the Searchable fields wizard in your form/flow or you can choose from meta data default columns that are available across all form and flow types. This list of metadata includes:

...

Image Added

Condition Column

The Condition column choices depend on the data type of the selected field. The Click below to see a list of the data types and their corresponding options are shown in the table..

...

For example, the choices in the Condition dropdown, will be different if you select the Submitted Date or the ProjectName, which is a searchable field in the form/flow from the Fields list.

...

The values entered into the Value Column depend on the field type and also sometimes upon the condition chosen. The Click below to see a table of the allowed values for Field Type(s) and conditions are listed in the table..

...

...

...

...

...

...

...

...

...

For Example, if you select a Date field, the Date Picker is provided to help enter the value. If you select a Text field from your form/flow, you will be prompted to "Enter text" for the value. If you select the Error metadata field, the value choices will be True or False in a dropdown in the Value column.

Info

A Date, Time or Date/Time field with the "is within last" condition selected, requires a special time duration entry. The duration must be entered in this format: Years:Months:Days:Hours:Minutes. Fields to the left may be omitted. For example, if you were searching for submissions that were submitted within the last 2 hours you can enter 02:00 or as 2:0. To search for submissions created within the last 2 months and 12 days, enter 02:12:00:00. Image Removed Image Added If you enter an invalid value, an error will display with instructions:

...

Some of the Action buttons on the upper right of the Submissions Table require the selection of one or more submissions while others do not. The function . Click below for a list of the buttons and their functions.

...

Submission Table Columns

The Submission Table displays all of the default columns plus columns for Searchable fields configured by the form/flow designer. Click below for a list and description of the default columns.

Default Columns

The table list the describes the default columns that appear in the Submission Table. You cannot change the order of the default columns but you can Show or Hide them in the Submission Table.

...

Expand
title Click here for a list of the default columns in submissions
Column Name Formatted Default Column Description Submitted Date/time Yes Time/date of the submission Error   Yes A Image Modified yellow icon in the Err column indicates the data was captured but there was an issue with the request.  For example, if you set the form action property to go to a URL after the user clicks Submit but the URL is invalid, you would see a Image Modified yellow icon. Or if the form action was set to send an email but the email address was missing, this will also cause a Image Modified yellow icon to appear on the submission. State Text Yes Submission status: SUBMITTED, PENDING, ABORTED, SAVED, ERROR WAITING. This column displays the submission types selected in the State section of the Submissions Filter. Error Description Text Yes Description of the error if the error column is true. Submitter ID Text Yes Live Forms user ID of the logged in tenant user submitting the form or blank if the form was submitted by an anonymous user. Submitter Name Text Yes First and Last Name of the logged in tenant user submitting the form or blank if the form was submitted by an anonymous user. Lock User ID Text Yes If the submission is currently locked (and not SUBMITTED), this is the user id who has it locked. Lock Date Date/Time Yes If the submission is currently locked (and not SUBMITTED), this is the time/date when it was locked. Lock User Name     Displays the First and Last name of the user who has a task locked, when viewing Pending tasks. Started Date Date Yes Date when the submission was created.  Age/Duration Days, Hours, Minutes Yes For completed submissions (State=Submitted) this is the time interval for how long it was in process - from the first incomplete submission (Pending, saved, etc.) until it reached SUBMITTED status. If the submission is currently incomplete (i.e. SAVED, PENDING or WAITING), then the time interval shows how long has it been in process so far (Age).

This image shows a PENDING submission for a Purchase Order workflow. The first step of the flow was submitted by a designer user (Submitter ID), Giorgio Armani (Submitter Name). It is currently pending approval by his manager, Jerry Mouse (Lock User Name). Jerry's user id is jerry (Lock User ID).

...

1. Cloud Customers:
   

   1. The maximum number of Searchable fields  fields is 20 per form/flow. 

   2. Edit each form/flow where Export to Excel is configured

      1. Click the Setup Searchable Fields link

      2. Click the Saved Fields tab and review the fields previously set up as Saved Fields

      3. Click the Searchable Fields tab and add every field into the Searchable Field list that was in the Saved Fields list

      4. Save your changes

   3. Email support@frevvo.com to request that the Insight Batch job be run on your tenant if you want to update older submissions with the changes.
      
      

2. In-house Customers:
   

   1. If you have forms/flows exporting more than 20 fields to Excel, add the frevvo.max.searchable.fields parameter to the frevvo.xml file

      1. Change the value to the number of searchable fields that you want.

   2. Edit each form/flow where Export to Excel is configured

   1. 1. Click the Setup Searchable Fields link

      2. Click the Saved Fields tab and review the fields previously set up as Saved Fields

      3. Click the Searchable Fields tab and add every field into the Searchable Field list that was in the Saved Fields list

      4. Save your changes

   2. Manually run the Insight batch job to if you want to update older submissions with the changes.

    

...