Jira Field Mapping

Owned by Sean Osawa
Last updated: Nov 06, 2024 by Khairul Danial
2 min read

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.

Â