Use a predefined function or create a formula to calculate a value for a column without writing a script in Table Builder. You can use two or more functions to create a formula according to your requirements.

Before you begin

  • The scope of the table should be within the scope of the application. Otherwise, you cannot add a formula to a column in the table that is outside the scope of the app.
  • Role required: personalize_dictionary or AES user role and delegated developer permissions. For more information, see Delegate developers using AES.

Procedure

  1. From the Data or Forms tabs, click the Open side panel icon (Open side panel icon) for a column.
  2. In the Config tab of Formula section, click + Add.
  3. Enter a predefined function or a formula in the Formula editor modal.Creating table using formula editor

    For example, to concatenate the First name column value with the Last name column value and populate the Full name column value, enter CONCATENATE(first_name,last_name). For more information about available predefined functions and example formulas, see Formulas for column values in Table Builder

    For syntax guidance and examples, click the function in the auto-suggestion that appears as you begin typing.
    Note: You cannot add a formula for unsupported columns, columns that are function fields, and the columns that already have script as the calculated value type.
  4. Click Submit.

Result

The formula is validated and added to the column if it doesn't have any errors.