...
| Expand |
|---|
| title | Click here for a list of the default columns |
|---|
|
Default Columns | | Description |
|---|
| Submitted Date | Time/Date of the submission. Also The Submitted Date is 'A' in the Submission Filter. | | Error | Shown as a yellow triangle if the there is a submission error. | | Error Description | Descriptive text about a submission error. | | State | Submission status: SUBMITTED, PENDING, ABORTED, SAVED, ERROR WAITING. This column displays the submission types selected in the State section. The submission status is 'B' in the submission filter. | | Submitter Id | ID of the last submitting user. | | Submitter Name | The first and last name of the user who submitted the form/flow. | | Lock User Id | If the submission is currently locked (and not SUBMITTED), this is the user id of the user who has it locked. | | Lock Date | Date and time a flow last locked. | | Lock User Name | If the submission is currently locked (and not SUBMITTED), this is the first and Last name of the user who has it locked. | | Started Date | Date and time a form/flow first started. | | Age/Duration | 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). |
|
Image Removed
Image Added
Condition Column
...
| Expand |
|---|
| title | Click here for a list of values available for field types and condtions |
|---|
|
Field Type | Condition | Value Entry Field Type | Notes |
|---|
| DateAny except 'is within last' | Date Picker | | | Time | Any except 'is within last' | Time Entry | | | DateTimeAny except | Date and Time Picker | The 'is within last' | Date and Time Picker | | Date, Time, DateTime | 'is within last' | Special time duration entry field. condition is available for DateTime controls only. It does not apply to Date or Time controls. If you select the "is within last" condition, you must: - Enter the value using a special time duration entry format
- Enter a duration in Years:Months:Days:Hours:Minutes. Any field to the left may be omitted. For example, 2 days and 4 hours may be expressed as 0:0:2:4:0 or as 2:4:0. Refer to the example below.
| | Number, Money, Quantity | | number field | | | Text, TextArea, Email, DropDown, Radio, Checkbox | | Text field | | | Boolean Checkbox | drop down containing true and false options | |
|
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:  |
...
Cloud Customers:
The maximum number of Searchable fields fields is 20 per form/flow.
- Edit each form/flow where Export to Excel is configured
Click the Setup Searchable Fields link
Click the Saved Fields tab and review the fields previously set up as Saved Fields
Click the Searchable Fields tab and add every field into the Searchable Field list that was in the Saved Fields list
Save your changes
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.
- In-house Customers:
If you have forms/flows exporting more than 20 fields to Excel, add the frevvo.max.searchable.fields parameter to the frevvo.xml file
Change the value to the number of searchable fields that you want.
Edit each form/flow where Export to Excel is configured
Click the Setup Searchable Fields link
Click the Saved Fields tab and review the fields previously set up as Saved Fields
Click the Searchable Fields tab and add every field into the Searchable Field list that was in the Saved Fields list
Save your changes
Manually run the Insight batch job to if you want to update older submissions with the changes.
...