Conditions
Conditions:
Conditions can be configured on current list fields, if the current list contains any lookup column, it is possible to configure conditions on lookup list fields as well. Column names dropdown in the condition builder shows lookup list fields with "lookup field name in current list:: lookup list field name" syntax.
  • Single Line Text Field
    Possible Values Syntax Example
    Direct Value Any text which does not contain reserved words like {, [, (, ), ], }, $ CCSTest
    Another Column Value [ColumnInternalName|ColumnDisplayName] [Status|RequestStatus]
  • Person or Group
    Possible Values Syntax Example
    Direct Value - Valid Display Name
    - Valid Email address
    - Pavan Kumar
    - pavan@crowcanyon365.com
    - pavan;#james
    Another Column Value [ColumnInternalName|ColumnDisplayName] [Status|RequestStatus]
    Note: It is not necessary that multiple user values specified in item field and condition value be in same order. As long as both contain the same set of users, condition will evaluate to true. For e.g. in condition it can be either ‘james;#pavan’ or ‘pavan;#james’ (same for Multi Choice and Multi Lookup fields also)
  • Date and Time
    Possible Values Syntax Example
    Direct Value - Date Only - MM/DD/YYYY
    - Date and Time - MM/DD/YYYY HH:MM:SS AM/PM
    Note: Date value should be as per site time zone
    - Date Only - 01/01/2017
    - Date and Time - 01/01/2017 05:25:00 PM
    Another Column Value [ColumnInternalName|ColumnDisplayName] [Due Date|DueDate]
  • Choice
    Possible Values Syntax Example
    Direct Value Any text which does not contain reserved words like {, [, (, ), ], }, $ High
    Another Column Value [ColumnInternalName|ColumnDisplayName] [Priority|Priority]
  • Multi Choice
    Possible Values Syntax Example
    Direct Value Value1;#Value2 Assigned;#In Progress
    Another Column Value [ColumnInternalName|ColumnDisplayName] [Priority|Priority]
    Note: It is not necessary that multiple column values specified in item field and condition value be in same order. As long as both contain the same set of values, condition will evaluate to true. For e.g. in condition it can be either ‘High;#Normal’ or ‘Normal;#High’ (same for Multi User and Multi Lookup fields also)
  • Lookup
    Possible Values Syntax Example
    Direct Value Any text which does not contain reserved words like {, [, (, ), ], }, $ Calendar
    Another Column Value [ColumnInternalName|ColumnDisplayName] [Category|Category]
  • Multi Lookup
    Possible Values Syntax Example
    Direct Value Value1;#Value2 Spam;#Calendar
    Another Column Value [ColumnInternalName|ColumnDisplayName] [Category|Category]
    Note: It is not necessary that multiple column values specified in item field and condition value be in same order. As long as both contain the same set of values, condition will evaluate to true. For e.g. in condition it can be either ‘Calendar;#Email’ or ‘Email;#Calendar’ (same for Multi Choice and Multi Lookup fields also)
  • Yes/No (Checkbox)
    Possible Values Syntax Example
    Direct Value - True
    - False
    - Yes
    - No
    Another Column Value [ColumnInternalName|ColumnDisplayName] [SendForApproval|SendForApproval]
  • Number or Currency
    Possible Values Syntax Example
    Direct Value Any valid number 100
    Another Column Value [ColumnInternalName|ColumnDisplayName] [Price|Price]
Privacy Statement
 Contact Us
Developed by
Copyright © 2018 Crow Canyon Systems, Inc. All Rights Reserved.