Overview
With Excel-like Tables for Jira, you can map any cell in a table with the Jira field, vice versa.
Read mapping: Copy the value of the Jira field into a specific cell.
Write mapping: Copy the value of a specific cell into the Jira field. Set the calculated results on the table to the Jira field, for example.
Map from the context menu (recommended)
Click the right button on a specific cell and select "Jira field" in the context menu. In the shown dialog, select a mapping direction and a target Jira field.
The mapped comment is colored light blue due to distinguish it from the normal comment, which is colored light yellow.
When is the data reflected in the mapped cell/filed?
Read: Jira field → Cell | Write: Cell → Jira field | |
|---|---|---|
Timing that read/write executed |
|
|
Notes | When you modify Jira fields, it needs reloading a page to reflect the changes to a table. | After write action, the table panel will be reloaded. |
Supported fields
Fields that have numbers, such as Number custom field.
Fields that have a string as a value, such as Summary, Description, Text custom field.
Map with the comment (alternative way)
You can map between a field and a cell by writing directives in a cell comment, too.
Step 1: Add a comment by selecting Insert Comment from the context menu
Step 2: Write a read/write directive on the comment
Read: Jira field → Cell | Write: Cell → Jira field | |
|---|---|---|
Notation on a comment | read-field <field name> | write-field <field name> |
Notes:
The first directive in a comment is used in the case there are multiple directives
You don’t have to put the field name in quotes