Build expressions using Expression Assistant

Build and test simple and complex expressions using Expression Assistant as described in the following sections.

See also:

Use Expression Assistant

Within the app editor, you can access Expression Assistant anywhere you're able to enter an expression.

To access Expression Assistant:

  1. Click the flask icon next to an input field to toggle to the expression format (if available). For example:

    Flask icon

  2. Click in the expression field indicated with an equals sign (=). For example:

    Expression field

Note: The equals sign indicates that the expression's result will be used as the setting's value.

Expression Assistant opens. The following figure shows an example of Expression Assistant.

Expression assistant with callouts

To build an expression using the Expression Assistant:

  1. Position your cursor in the text area where you want to insert new content.
  2. Expand and collapse tabs, as desired, for more screen space to see your expression.
  3. Construct your expression:
  4. Confirm the validity of the expression.
  5. Test the expression, if desired.

View and insert column references into expressions

View and insert column references into expressions by clicking the Data Explorer tab, as shown in the following figure.

View and insert table columns into expression

Data Explorer tab enables you to:

  • View all tables and columns in your app
  • Insert a column reference into an expression, as described below
  • View Ref associations (references to other tables)
  • Expand and collapse table, and pin their display in Expression Assistant

To insert a column reference into an expression:

  1. Click within the expression text area where you want to insert the column reference.
  2. Expand the table that contains the column you want to add.
  3. Position your cursor over the column name and click Insert.

View and insert predefined patterns into expressions

View and insert predefined patterns into expressions by clicking the Examples tab, as shown in the following figure.

View and insert example patterns into expressions using the Examples tab.

The Examples tab enables you to:

  • Select an expression type
  • Insert a predefined pattern into an expression, as described below

To insert a predefined pattern into an expression:

  1. Click within the expression text area where you want to insert the example pattern.
  2. Select the tab based on the expression type that you want to add.
  3. Position your cursor over the example pattern and click Insert.

Test expressions

To test the results of the expression for each row in the table, click Test in Expression Assistant. The Expression Test page displays.

The first column shows the Expression Result for each row in the table, as shown below:

Expression results for each row in table

Expand the Expression Result by clicking the expand icon to view the results of each part of the expression:

Expression results expanded

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false