Update grid data with Single Select List column type
This example use a grid with products, product prices, and total price to update grid data based on another column.
You will also learn how to use several features in TGNG app such as:
Introduction
This example use a grid with products, product prices, and total price. The price and total prices will update after we select a specific product in a grid. By practicing this use case, user can use Jira project for sale management where they can continuously update new order/bill in ticket.
Prerequisites
User logged into their account, installed Table Grid Next Generation Server / Datacenter app
User created a related Jira project
User had the admin role on Jira
Post-condition
User can use the grid to update related information for the list of items
User can use the calculation on the Table Grids in Issues/Tasks.
Basic Flow
Steps |
|
1 | Fill in the information for “Name” and “Description” in the “Grid Field” section  |
2 | Create “Add new column”, choose “Single Select List” for “Column type”.  |
3 | Type the name: “Product” for the “Title” and set unique variables in “Identifier” to identify the column. |
4 | Click the “+” button on the “Option attributes” to add options for the “Product” column. The column will have these option attributes:
|
5 | Click the “+” button on the “Static options” to fill information for each option. |
6 | Click “Add” to save the column. |
7 | Create “Add new column”, choose “Number” for “Column type”. |
8 | Type the name: “Amount” and set unique variables to identify the column for “Identifier”. |
9 | Click “Add” to save the column. |
10 | Create “Add new column”, choose “Formula” for “Column type” to create 3 new columns. |
11 | Type the name: “Price”, “Total Price” and “Currency” and set unique variables in “Identifier” to identify the column. |
12 | The “Price” column will reuse the data from the “price” option attribute from the “Product” column. To do so, we will input the following formula: return $(product).price |
13 | The “Total price” column will multiply the data from the price option attribute by the data from the “Amount” column. To do this, we will use the formula: return $(price) * $(amount) |
14 | The “Currency” column will display the data from the currency option attribute from the “Product” column. We will use the following formula to do this: return $(product).currency |
15 | Click “Add” to save the column. |
16 | Click “Save” to save the configuration |
Exceptional Flow
Users type wrong calculation
Continued from step #12 in the Basic Flow:
Step | Description |
13 | If the user enters the wrong calculation, the system will show one of the following:
|
Use case stops. | |
Users click “Cancel” at “Edit Column”
Continued from step #5 in the Basic Flow:
Step | Description |
6 |
|
Use case stops. | |
Users don’t click “Save” at “Configuration”
Continued from step #4 in the Basic Flow:
Step | Description |
5 |
|
Use case stops. | |
Use the grid in a Jira Project
Create a Jira project
1/ Click “Create project”
Within the chosen Software Project, type Jira Project = Sale Management, project key = SALE
Grid configuration file
2/ To go faster you can import this grid configuration =
Add grid on project screens
2/ Add grid on screens
In Issues, click Screens
In the selected screen, click Configure to add grid to the screen.
Create sale management (issue)
3/ Then create issue with the Sale Management grid