Excerpt | ||
---|---|---|
| ||
Example of how you can build a riving table and use it to display dependent list values in a grid. |
(This feature is supported on version 1.11 and higher of the add-on)
Use case
Assume that you want to create a grid to enter line items on a quote (for instance to quote expensive cars)
The grid should allow the user to select from a drop down list a product, price and description are automatically set:
A total is calculated once that a unit is set
Grid configuration
...
The custom field itself can be configured as follows
...
Although not strictly necessary for this use case, you can use JIRA to host the driving table containing all the products the user can choose from.
The configuration of this driving table is
Check the driving table configuration example
Code Block |
---|
gd.columns = product, price, idescription gd.ds = jira gd.tablename = products col.product = Product col.product.type = string col.product.required = true col.product.width = 200 col.price = Price col.price.type = number col.idescription = Description col.idescription.type = textarea col.idescription.rows = 5 col.idescription.cols = 50 |
...