Versions Compared

Old Version 8

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

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

...

Expand
titleClick here for a list of values available for field types and condtions

Field Type

 ConditionValue Entry Field TypeNotes
DateAny except 'is within last'Date Picker 
TimeAny 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: 

...

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

     

...