Skip to main content
Skip table of contents

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.

      Screenshot 2024-11-06 at 1.52.10 AM.png

    • Right-Click Option: Alternatively, you can simply right-click on the cell and select Jira Field Mapping from the context menu.

      Screenshot 2024-11-06 at 1.55.40 AM.png

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

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close