General help

• Adding Attributes to a formula
• Adding Attribute Labels to a formula
• Adding a Line Feed when concatenating
• Accessing URLs for Image and File attributes within formulas
• Accessing Identifier and SystemID values

Functions

• LOWER([Attribute Name]) Function
• UPPER([Attribute Name]) - Convert a string value of an attribute to uppercase
• CHAR(Integer) - Returns the character specified by the code number
• CONCAT([Attribute Name] or String,[Attribute Name] or String,[Attribute Name] or String..) - joins together multiple attribute values or other stings
• IF(Logical Expression, Do this if True, Do this if False) - take an action based on a set of conditions in a Logical Expression
• ISBLANK([Attribute Name]) - check for a blank attribute value
• NOT(Logical Expression) - Returns the opposite of the logical expression
• CONTAINS([Attribute Name], String) - Returns true if the attribute value contains the specified string and false if not.
• STARTSWITH([Attribute Name], <String>) - Returns true if the attribute value starts with the specified string and false if not.
• ENDSWITH([Attribute Name], <String>) - Returns true if the attribute value ends with the specified string and false if not.
• LEFT([Attribute Name], <Number of Characters>) - Returns the specified number of characters (substring) from the start of a string.
• RIGHT([Attribute Name], <Number of Characters>) - Returns the specified number of characters (substring) from the end of a string.
• WEBDESIGNURL(”DesignID”) - generate a URL for a Web Design specified by the design ID e.g. WEBDESIGNURL(”DES-11-1”)