Are you using lists of values in the Table Grid Editor for Jira Server and you want a simple way to manage its lists, check out the Driving Table editor.
The driving table editor allows you to create and manage these lists in the same way as you create and manage table grids.
Use case - the product list
In this example JIRA and the table grid editor are used to manage quotes.
JIRA is used to track the status of a quote, and the Table Grid Editor is used to list all the line items in the quote.
One of the columns contains a list of available products. This dynamic list is based on a driving table, maintained in the JIRA table grid editor admin.
Configure the products columns in the Quote Line items table
To ensure that the line items refer existing products, products are retrieved from a database table 'products'. Notice, that price is taken from the same lookup table from another column.
Configure the driving table - Products
Using a driving table you can actually edit the list of values presented to the user.
In the JIRA administration navigate to Add-ons - on the left menu, under Table Grid Editor administration choose Driving Table Admin
Now you can see the Driving Table admin page where you can manage driving tables:
- add a new table
- modify the existing table
Use the same approach to configure the driving table as you used to configure the table grid
Note that a number of grid properties don't apply. More details are available on the Driving Tables - configuration page.
Driving Table access
By default only administrators can access the Driving Table Admin.
You can also grant users permissions to access the Driving Table. In order to do that, create an igrid-admin user group and add users to the group.
A user will get a separate menu tab with Driving Tables access.
The user has access to the list of existing driving tables, can create a new driving table, add/edit data in the existing one.
The access is limited and it's not possible to remove or change existing configurations.
More advanced configurations
More advanced configurations are possible such that you can model any information. For instance if you want to create a pricing table where prices depend on the product and the tier: