...
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.
| Expand |
|---|
Data Type(s) | | Conditions Available in the Dropdown List |
|---|
| Date, Time, Date/Time | is equal to | | | is not equal to | | | is after | | | is before | | | is on or before | | | is on or after |
|
...
| only available for Date/Time controls | is within last | | | contains a value | | | does not contain a value | | Number, Money, Quantity | is equal to | | | is not equal to | | | is greater than | | | is less than | | | is greater than or equal to | | | is less than or equal to | | | contains a value | | | does not contain a value | | Text, TextArea, Email, DropDown, Radio, Checkbox | contains | | | does not contain | | | begins with | | | ends with | | | is equal to | | | is not equal to | | | contains a value | | | does not contain a value | | Boolean Checkbox | is equal to |
|
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.
| Section |
|---|
| Column |
|---|
Condition Choices when a Date field is selected from the Fields list. |
| Column |
|---|
Condition Choices when ProjectName, a text field in the Expense Report workflow, is selected 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.
| Expand |
|---|
Field Type | | Condition | Value Entry Field Type | Notes |
|---|
| Date | Any except 'is within last' | Date Picker | | | Time | Any except 'is within last' | Time Entry | | | DateTime | Any except 'is within last' | Date and Time Picker | | | Date, Time, DateTime | 'is within last' | Special time duration entry field. | 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. | | 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.
...