Excerpt | ||
---|---|---|
| ||
You can execute different operations using formulas in the gird. the formula is based on JavaScript. |
This guide shows how to use formulas create a formula column in the Table Grid Next Generation for Jira Cloud. A Formula is a separate column type based on JavaScript. The
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 . To use a formula in a gird, add a separate column using formula column type, input .
Configuration
Input formula inside embedded embedded JavaScript Ace Editor and get results on the grid.
You can It's possible to execute different operations using formulas in the gird. Use JavaScript to create . To create the formula expression use JavaScript.
Let's create the formula column:
Prerequisites: configured gird and columns. You need other columns in the grid to create a formula expression.
...
Add a new column to the grid, using formula column
...
type
...
...
- 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.
Input the formula, based on the
...
grid columns' IDs.
Warning title Attention Use column IDs in the formula expression.
Code Block language js theme Eclipse title Formula code example if($(calculate)){ return $(salary) + $(bonus) } else { return $(salary) }
Info | ||
---|---|---|
| ||
|
- Save changes.
Congratulations! You just created your first formula column. Now you can use formulas in the Table Grid Next Generation for JIRA Cloud..
Check more examples on the formula configuration page.
...