You are here:
Reactive Screen Flow Formula Operators
A subset of the formula operators supported in screen flows support reactivity.
Required Editions
| View supported editions. |
When a formula with these operators references components that support reactivity on the same screen, the flow recalculates the formula in real time when the values of the referenced components change.
| Supported Formula Operators and Functions | Type |
|---|---|
| + | Math Operator |
| - | Math Operator |
| * | Math Operator |
| / | Math Operator |
| ^ | Math Operator |
| = | Logical Operator |
| <> | Logical Operator |
| < | Logical Operator |
| > | Logical Operator |
| <= | Logical Operator |
| >= | Logical Operator |
| & and + (Concatenate) | Text Operator |
| ADDMONTHS | Date and Time Function |
| DATE | Date and Time Function |
| DATEVALUE | Date and Time Function |
| DATETIMEVALUE | Date and Time Function |
| DAY | Date and Time Function |
| MONTH | Date and Time Function |
| NOW | Date and Time Function |
| TODAY | Date and Time Function |
| WEEKDAY | Date and Time Function |
| YEAR | Date and Time Function |
| AND | Logical Function |
| BLANKVALUE | Logical Function |
| CASE | Logical Function |
| IF | Logical Function |
| ISBLANK | Logical Function |
| ISNULL | Logical Function |
| ISNUMBER | Logical Function |
| NOT | Logical Function |
| NULLVALUE | Logical Function |
| OR | Logical Function |
| ABS | Math Function |
| CEILING | Math Function |
| EXP | Math Function |
| FLOOR | Math Function |
| LN | Math Function |
| LOG | Math Function |
| MAX | Math Function |
| MCEILING | Math Function |
| MFLOOR | Math Function |
| MIN | Math Function |
| MOD | Math Function |
| ROUND | Math Function |
| SQRT | Math Function |
| BEGINS | Text Function |
| CONTAINS | Text Function |
| FIND | Text Function |
| LEFT | Text Function |
| LEN | Text Function |
| LOWER | Text Function |
| MID | Text Function |
| RIGHT | Text Function |
| SUBSTITUTE | Text Function |
| TEXT | Text Function |
| TRIM | Text Function |
| UPPER | Text Function |
| VALUE | Text Function |
| TIMENOW | Time Function |
| TIMEVALUE | Time Function |
| HOUR | Time Function |
| MINUTE | Time Function |
| SECOND | Time Function |
| MILLISECOND | Time Function |
| INCLUDES | Advanced Function |
Considerations
-
Reactivity isn’t supported on cross-object formulas, which are formulas that span two related objects and reference merge fields on those objects. For example, consider an Account selected in a Data Table. The account Name, for example
myContactDataTable.FirstSelectedRow.Account.Name, isn’t reactive and doesn’t appear in any components referenced on the same screen. - If a reactive formula relies on a field with an initial value of
null, the flow doesn’t calculate the formula until the user supplies a value. To ensure that your reactive formulas function as expected, consider null values in your configuration. If needed, use theBLANKVALUEformula operator to set null values to zero:BLANKVALUE({!resource},0). - Reactive formulas are limited to 3,900 characters. When you save a formula, Salesforce adds characters to ensure that the formula functions properly. Consequently, your formula can exceed the character limit even if the number of characters you supplied is below the limit. If you exceed the character limit, reactivity isn’t supported.
Did this article solve your issue?
Let us know so we can improve!
