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. For example, set the calculated results on the table to the Jira field.field’s value to the table’s cell and vice versa.
...
Map from Jira view issue screen
Click the right button on a specific cell and select "Jira Field Mapping" in the context menu.
...
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 target Jira field.
...
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 with numbers, such as a Number custom field.
Fields with a string as a value, such as Summary, Description, and Text custom fields.
Map with the comment (alternative way)
You can map between a field and a cell by writing directives in a cell comment.
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. |