/
Jira Field Mapping

Jira Field Mapping

Overview

With Excel-like Tables for Jira, you can map the Jira 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.

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

  1. Select the Cell: Click on the specific cell you want to map within your spreadsheet.

  2. 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

 

Read: Jira field → Cell

Write: Cell → Jira field

Timing that read/write executed

  • Table loaded

  • Comment changed

  • Table saved

Supported Fields

  • Single select, multi select

  • Attachments

  • User Fields

  • Issue Fields (Status, Priority)

  • Date Fields

  • Date & Time Fields

  • Numbers Field

  • Text Field

Notes

  • Page Reload Required: After modifying Jira fields, reload the page to ensure changes are reflected in the table.

  • Attachment Field Mapping: This option is available only when the issue already contains an attachment.

Automatic Page Reload on Save: The issue page will reload upon saving if a Cell-to-Field mapping is configured on the sheets.

 

Related content

Search with JQL
Read with this
View Jira Field Mapping Summary
View Jira Field Mapping Summary
More like this
Jira Issues Sheet
More like this
Auto-populate Jira Issue with a Table
Auto-populate Jira Issue with a Table
More like this