New to expressions and formulas? Try Expressions: The Essentials.
You can also learn more about the types of expressions you can use in your app.
Expression Builder can be found anywhere you're able to enter a expression, noted by a "flask" icon next to it. Clicking on the flask will bring up Expression Builder. Expression Builder is context-aware, meaning it shows expressions relevant to the specific table being edited. An instant expression checker is also included in the builder to verify the expression is valid.
In the editor, you will see this flask icon:
The flask icon opens Expression Builder in the Columns tab of the Data pane in the app editor; elsewhere, it opens Expression Assistant. The two are slightly different: Expression Builder looks a little different than Expression Assistant, and doesn't have the ability to check expressions instantly.
To access Expression Builder, go to the Columns tab and select the Edit icon, circled in red below.
Then, select the flask icon attached to the field for which you would like to create an expression.
Expression Builder has 3 sections:
1 (Red): Pre-made expressions you can use for reference, or click the Copy button to copy the expression to the editing area.
2 (Blue): Editing area where you can type your expression.
3 (Orange): Verify button used to check that your expression is correct.
4 (Green): Test button used to open the expression tester (see below).
5 (Pink): OK button to save changes and close Expression Builder.
Expression Assistant is the new form of expression builder; it can be used most places where you see a flask icon in the app editor. Like Expression Builder, it has several different categories of expressions from which to choose. You can also select the Test button to see how your expression works. The green check mark indicates that your expression's syntax is correct.
The Expression tester is used to quickly preview what the expression result is for each row.
In addition to the expression result, you can expand the expression to see what each step of the expression does.