Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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.

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 a specific cell and select a mapping direction on the ribbon 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

  • Table loaded

  • Comment changed

  • Table saved

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

  • You don’t have to put the field name in quotes

  • No labels