The filter can be applied to multiple fields at once using the following format:
Multiple-filter format:
AND((Field;Operator;Value),(Field;Operator;Value))
OR((Field;Operator;Value),(Field;Operator;Value))
Single filter format:
Field;Operator;Value | Note |
|---|
Multiple-Filter Format Precautions: Within a multiple-filter format, leaving a response value blank could lead to unexpected behaviour or errors. It's strongly advised to input valid response values to maintain proper filtering functionality. Remember, these response values are case sensitive and must precisely match the values recorded in the submission for effective filtering. |
The following Data Types are supported by the filter:
MSPL, Phone, Text, Picklist, Date, Number, Currency, Percent Case-Sensitive Operator Values: When entering the operator value as part of the filter, ensure it is in uppercase letters, strictly following the specifications outlined in the Operator Label column of the provided table. Data Type | Operator LabelOperator Value | Example: | MSPL | IncludesINCLUDES | | | Excludes | EXCLUDES | Phone | Equals | '=' | | | Not equal to | !=' | | ContainsLIKE | | Does not containNOT LIKE | Text, Picklist | Equals | = | ampi__Status__c;Equals;In Progress For a custom field:
Narrative_Type__c;Not equal to | !=;Budget | | Not equal to | | Starts withLIKE% | | ContainsLIKE | | Does not contain | NOT LIKE | Date, Number, Currency, Percent | Equals= | | | Not equal to | != | | Less than | < | | Greater than | > | | Less or equal | <= | | Greater or equal>= |
| Info |
|---|
Phone Data Type Filter: The value passed in the filter for the Phone Data Type should be unformatted. For instance, use unformatted numbers (e.g., 1234567891) instead of formatted ones (e.g., (123) 456-7891). This ensures compatibility and accurate filtering. Date Data Type Filter: When utilising the Date Data Type filter, ensure the value is formatted in the YYYY-MM-DD format. This format standardises date input for consistent and effective filtering. Text/Picklist/Phone/MSPL Data Type Recommendations: To prevent unexpected errors or behaviour, refrain from using response values containing specific symbols like "_", ";", and “,” for Text, Picklist, Phone, and MSPL Data Types in your filters. This practice minimizes the potential for issues and ensures smoother operation.
|
|