Compares one expression to one or more other expressions. When the base expression matches a search expression, returns the corresponding result expression. When no match is found, returns the default expression when specified, or null when it is not. This function is similar to an if-then function.
decode(expr, search, result [, search , result]... [, default])
For a description of the business object categories, see Notes on "Enabled For".
|Business Object Category||Yes/No|
|Business Rules: Before-Save Rules||Yes|
|Business Rules: Calculation Rules (After Save, with or without Also Recalculate on Load)||Yes|
|Business Rules: Calculation Rules (Before Save or Always, without Also Recalculate On Load)||Yes|
|Business Rules: Calculation Rules (Before Save or Always, with Recalculate On Load)||Yes|
|Business Rules: Editing Rules||Yes1|
|Business Rules: Initialization Rules||Yes|
|Business Rules: Read Only Rules||No|
|Business Rules: Required Rules||Yes1|
|Business Rules: Validation Rules||Yes|
|Quick Actions (except UI Quick Actions)||Yes|
|UI Quick Actions||No|
|Search/Dashboard without field references||Yes|
|Search/Dashboard with field references||No|
|1. Except when this field appears on a form or is triggered by such a field.|
This function must have at least four parameters, and can have an unlimited number of parameters.
|expr||Expression to evaluate.|
|search||Text to match exactly with the search expression.|
|result||Value to return if the previous search text is matched.|
|default||Value to return if no matches are found.|
Number value or text value.
$(decode("Impact", "High", 1, "Medium", 2, "No Matches"))
If the field called Impact has the value High, then this functions returns 1. If the field called Impact has the value Medium, then this function returns 2. If the field called Impact has any other value, this function returns the text value "No Matches".