The contains formula is used to determine if an assigned attribute value contains a specific string (at the same level: member, crew or group). By default, a “Y” will be returned in the badge if the attribute contains the searched value and a “N” will be returned if the attribute does not contain the searched value.
Note: The searched string is case sensitive. Meaning, if the formula is looking for Upgrade but the value assigned to an employee is upgrade, the formula will return a "N" because the casing does not match.
Format: contains (attribute, string)
The attribute can be configured to search for one string or multiple strings. To search for multiple strings, separate the values by commas.
Format: contains (attribute, string1, string2...)
Example:
-
contains (SchedComment,Upgrade)
-
contains SchedComment,Upgrade,upgrade)
Reminder
The formula, attribute name and data point must be spelled and in the same case as the formula, attribute or data point you are referencing.
E.g. If an attribute is called CrewType, in the formula, you must use CrewType. crewType and CREWTYPE will not reference the CrewType attribute.
Comments
0 comments
Please sign in to leave a comment.