jira table in issue screen formatting cell dynamically and cell sum

[matt]

I would like to see if there is a way in Jira to create a table in the issue screen that is able to highlight cell dynamically and calculate sum.

[Pasam Venkateshwarrao]

Hi @matt 

Welcome to the community,

Yes this can be possible through Add-on

 Table Grid Next Generation for Jira Cloud, This features  includes, such as calculated cell values or conditional cell shading. If you are looking to get as close as you can to an Excel-like table, this plugin is likely your best bet.

Depending on what your specific use case is, you can also take advantage of Wiki-markup tables if you just need the "look" of a table without any advanced functionality. However, there are some implications for your Jira instance  you should be aware of if you choose to change the renderer for a custom field.

To do this, you will need to create a custom field and then specify the field's behaviour:

1. Create a multi-line text custom field and add it to the issue create/view/edit screen.
2. Create a new field configuration for this project:
   1. Select the Jira icon > Jira settings > Issues.
   2. Under FIELDS, select Field Configurations to view all your field configurations.
   3. Click the Add Field Configuration button to open the Add Field Configuration dialog box.
   4. Complete the Add Field Configuration dialog box:
      
      
      • Name — enter a short phrase that best describes your new field configuration.
      • Description (optional but recommended) — enter a sentence or two to describe when this field configuration should be used.
   5. Click the Add button to add your new field configuration to Jira. Once you have added your new field configuration, you will be taken directly to the View Field Configuration page, where you can modify the field behavior of the new custom field in your new field configuration.
3. In the View Field Configuration page, find the custom field you created and click on Renderers in the Actions column.
4. in the Active Renderer dropdown, select Wiki Style Renderer and click Update.

You can now use Jira's text formatting notation guide to place a table inside of this custom field, by editing the custom field value in an issue using the following notation:

||heading 1||heading 2||heading 3||
|col A1|col A2|col A3|
|col B1|col B2|col B3|

Hope this helps

[matt]

Passam, 

Thankyou for your help, your instructions make sense. Using the Wiki-markup method is there a way to put a custom field in the cell, so I can attach it to a listener to send an email if the field is out of limit? Also, will it allow me to sum up the column values to have a total?

If not, what is the best app that will do this, its very likely I am using Server version of Jira not cloud.

[Pasam Venkateshwarrao]

@matt the add-on which I shared it will support for jira server as well

[matt]

It may not be feasible to get an add on, is it possible to have say 3 fields in one row of a screen instead of the typical one field per row?

[Pasam Venkateshwarrao]

@matt In that case you can use single choice field type in the screen

[matt]

I would like to allow the user to input 3 different pieces of data on one row, is that possible, a single field type won't allow this?

[Pasam Venkateshwarrao]

@matt you can try with multi line text custom field which I have shared in the first reply,if you need table then it will be possible only with Add-on.without add-on it’s not possible

Hope you understand 

[matt]

Is it possible for me to do some coding to get this to work with a table and total? What would I need to start developing with data center?

Is it possible to use scriptrunner in any way possible using html? Getting an add on does not sound like something I can have done.