Overview
With Excel-like Tables for Jira, you can map any cell in a table with the Jira field, field’s value to the table’s cell and 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 by the ribbon menu on Full-featured editor (recommended)
Select a specific cell and select a mapping direction on the ribbon menu.
...
In the shown dialog, select a target Jira field.
...
Map from the context menu on Jira issue (recommended)
...
Map from Jira view issue screen
Click the right button on a specific cell and select "Jira Field Mapping" in the context menu.
...
Select a mapping direction and a target Jira field in the shown dialog.
...
The field with Jira mapping is colored with a light blue color to distinguish it from the normal comment, which is colored light yellow.
...
Map from the Full-featured editor
Select the Cell: Click on the specific cell you want to map within your spreadsheet.
Choose Your Mapping Option:
Ribbon Menu Option: Go to the ribbon menu at the top, select the Jira Operation tab, and choose Mapping Direction.
Right-Click Option: Alternatively, you can simply right-click on the cell and select Jira Field Mapping from 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
...
Supported Fields |
|
|
|---|---|---|
Notes |
| Automatic Page Reload on Save: The issue page will reload upon saving if a Cell-to-Field mapping is configured on the sheets. |