Build and test simple and complex expressions using the Expression Assistant as described in the following sections.
Using the Expression Assistant
Within the app editor, you can access the Expression Assistant anywhere you're able to enter an expression.
To access the Expression Assistant:
Click the flask icon next to an input field to toggle to the expression format (if available). For example:
Click in the expression field indicated with an equals sign (=). For example:
Note: The equals sign indicates that the cell is equal to the expression being evaluated.
The Expression Assistant opens. The following figure shows an example of the Expression Assistant.
To build an expression using the Expression Assistant:
Position your cursor in the text area where you want to insert new content.
Expand and collapse the tabs, as needed, for more real estate when building your expression.
Perform one of the following tasks:
Confirm the validity and function of the expression.
Test the expression, if desired.
Viewing and inserting table columns into expressions
View and insert table columns into expressions by clicking the Data Explorer tab, as shown in the following figure.
As highlighted in the previous figure, the Data Explorer tab enables you to:
View all tables and columns in your app
Insert a table column into an expression (described below)
Expand, collapse, and pin tables
To insert a table column into an expression:
Click within the expression text area where you want to insert the table column.
Expand the table that contains the column you want to add.
Position your cursor over the table column and click Insert.
Viewing and inserting example patterns into expressions
View and insert example patterns into expressions by clicking the Examples tab, as shown in the following figure.
As highlighted in the previous figure, the Examples tab enables you to:
Select an expression type
Insert an example pattern into an expression (described below)
To insert an example pattern into an expression:
Click within the expression text area where you want to insert the example pattern.
Select the tab based on the expression type that you want to add.
Position your cursor over the example pattern and click Insert.
To test the results of the expression for each row in the table, click Test in the Expression Assistant. The Expression Test page displays.
The first column shows the Expression Result for each row in the table, as shown below:
Expand the Expression Result by clicking the expand icon to view the results of each part of the expression, as shown below: