UPPER

Use the UPPER function to convert all lowercase letters in a Text value to uppercase letters.

Use

UPPER( text )
Converts text to uppercase.

Parameter	Required	Description
text	Yes	the text to convert

Returns

Text

Examples

Standardizing Department Codes (Variable Update)

When users enter data into a trigger form, they may use inconsistent casing (e.g., "finance," "Finance," or "FINANCE"). You can use the UPPER function in a Variable Update formula to normalize this data before it is stored in a variable or used in a report.

• Scenario: A "Procurement" trigger captures a department name in a field called DeptName. You want to store this in a variable named $DeptCode entirely in capital letters for your accounting system.
• Formula: UPPER(@Trigger.out.DeptName).
• Logic: The function takes the output from the trigger and converts every character to uppercase.
• Result: If the user entered "marketing," the variable $DeptCode will be updated to "MARKETING".

Case-Insensitive Branching (Path Condition)

You can use UPPER within a Path Condition on a Conditional Branch to ensure that a workflow follows the correct route regardless of how the user typed a specific keyword.

• Scenario: An approval path depends on a "Priority" field. You want the "Urgent" path to be taken if the user types "urgent" in any case combination.
• Formula: UPPER(@Trigger.out.Priority) = "URGENT".
• Logic:
  • UPPER(...): Converts the user's input (e.g., "Urgent" or "uRgEnT") to "URGENT".
  • = "URGENT": Compares the result to the uppercase literal string.
• Result: The formula returns TRUE for any variation of the word "urgent," ensuring the approval correctly routes to the high-priority path.