How to create formula

This guide shows how to create a formula column in the Table Grid Next Generation.

You can input formula inside embedded JavaScript Editor and get results on the grid view. The grid can process formula logic and display formula results in a separate column.

Configuration

Input formula inside embedded JavaScript Ace Editor and get results on the grid.

It's possible to execute different operations using formulas. To create the formula expression use JavaScript. 

Prerequisites: configured grid and columns. You need other columns in the grid to create a formula expression. 

  1. Add a new column to the grid, using formula column type 

  2. Input column's details:

    Column type - select Formula type.
    Identifier - a unique variable to identify the column. Required field - you can set the desired value here.
    Title - 
    column title, displayed in the grid. 
    Column IDs - 
    list of existing columns' IDs. Use in order to create a formula.
    Formula expression - embedded JavaScript editor, where you need to input your formula. Uses Ace Editor, which highlights the syntax. 
    Summary Label - label name, that will be used in the column summary.
    Aggregation operation -  select aggregation operation of the column data: sum, average, min/max or custom formula.
     
  3. Input the formula, based on the grid columns' IDs.

    Attention

    Use column IDs in the formula expression.

    Formula code example
    if($(calculate)){
        return $(salary) + $(bonus)
    } else {
        return $(salary)
    }
  4. Save changes.

Congratulations! You just created your first formula. 


Check more examples on the formula configuration page.