An expression consists of operands and operators, or just one operand. For example, n + 1 is an expression with two operands, n and 1, joined by the addition operator +.
If you are creating an expression and encounter errors, check here for the causes and the actions you can take to resolve them.
Here is how you can edit expressions and show the expression values.
Use the expression editor to edit expressions. The expression editor shows you available elements. It automatically completes the text and shows suggestions after you press Ctrl+Space.
Edit expressions inline in the properties of elements.
To show the result of an expression, use the expression widget. This is similar to the print command in other programming languages.
We've been working on this article. Please let us know how useful this new version is by voting.
Here are some tips for using expressions.
You can use many functions to manipulate the type Text, however, you can only use the + (addition) operand with type Text.
"Hello, " + UserName, where the value of UserName is Billy, returns
You can use the built-in functions to perform various operations on the types Date, Time, and DateTime.
AddDays(#2020-01-01 00:00:00#, 90). AddDays is a function that adds n days to a Date Time value. Date Time is here a literal
#2020-01-01 00:00:00#. The expression returns
You can only use the operators = and <> (equality operators) for the type
For the type Identifier, use the built-in functions.
The types BinaryData and Record List don't support calculations.