Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt
hiddentrue

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

...