Gallery
Jira Pack guide
Share
Explore
Bring Jira issues into Coda

icon picker
Add tables with Jira issues

This page describes how to add a new Issues tables to Coda. You can watch the two-minute video walkthrough or follow along with the written instructions and screenshots.
Please copy this doc if you wish to review the formulas for each table column.
Copy doc

Video walkthrough

Watch a short video to set up your first Jira table. Alternatively, you can follow the written instructions below.

Written instructions and screenshots

1. Add a new Jira Issues or Projects table: (2 ways to add a table)

There are 2 ways to add a table to your Coda Doc.

2. Sync your table:

Once you add a table to your doc, you will likely see a blank table like the below. Click on Choose what to sync.
image.png
If you see the below options in the side menu, click connect an account.
image.png
Select the account you would like to connect (usually this is your company Jira domain).
image.png
Click finish installing.
image.png
Your table will now look like this. Click start sync.
image.png
While the table syncs, you will see the below message.
image.png

3. Hide unnecessary columns:

4. Optional: Create text copies of important attributes for easier reporting

Jira sends issue details to Coda in one large package of information. As you can see when you hover over one of the issues below, each issue references all information associated with it, including the issue status, assignee, URL, description, etc. This package of information can be problematic when you want to report on individual fields, such as status or assignee. One way to make your reporting easier to to create new columns for important fields that will be used in reporting. See a few examples below.
Convert important fields to plain text to make reporting easier
8
Issue
Key
Summary - Text
Status
Status - To Text
Sprint
Sprint Name (Text)
Concatenated Text Description
1
Lightening - This is the title for my new Jira bug!
DELO-29
Lightening - This is the title for my new Jira bug!
To Do
To Do
DELO-29 Lightening - This is the title for my new Jira bug! (To Do)
2
This is the title for my new JIRA bug
DELO-28
This is the title for my new JIRA bug
To Do
To Do
DELO-28 This is the title for my new JIRA bug (To Do)
3
This is the title for my new JIRA bug
DELO-27
This is the title for my new JIRA bug
To Do
To Do
DELO-27 This is the title for my new JIRA bug (To Do)
4
Lightening - This is the title for my new JIRA bug
DELO-26
Lightening - This is the title for my new JIRA bug
To Do
To Do
DELO-26 Lightening - This is the title for my new JIRA bug (To Do)
5
Use of long pole to harness lightening is not scalable
DELO-25
Use of long pole to harness lightening is not scalable
To Do
To Do
DELO Sprint 2
DELO Sprint 2
DELO-25 Use of long pole to harness lightening is not scalable (To Do)
6
Perform testing
DELO-7
Perform testing
To Do
To Do
DELO-7 Perform testing (To Do)
7
Vehicle does not perform correctly if speed is not exactly 88 miles/hr
DELO-6
Vehicle does not perform correctly if speed is not exactly 88 miles/hr
In Progress
In Progress
DELO Sprint 1
DELO Sprint 1
DELO-6 Vehicle does not perform correctly if speed is not exactly 88 miles/hr (In Progress)
8
Complete initial design
DELO-5
Complete initial design
Done
Done
DELO Sprint 1
DELO Sprint 1
DELO-5 Complete initial design (Done)
9
Flux capacitor construction and design
DELO-4
Flux capacitor construction and design
To Do
To Do
DELO-4 Flux capacitor construction and design (To Do)
10
Steal plutonium from the bad guys
DELO-3
Steal plutonium from the bad guys
In Progress
In Progress
DELO Sprint 1
DELO Sprint 1
DELO-3 Steal plutonium from the bad guys (In Progress)
11
Mall Meetup Roadmap Planning
DELO-2
Mall Meetup Roadmap Planning
To Do
To Do
DELO Sprint 1
DELO Sprint 1
DELO-2 Mall Meetup Roadmap Planning (To Do)
12
1.21 Gigawatts Workstream
DELO-1
1.21 Gigawatts Workstream
To Do
To Do
DELO-1 1.21 Gigawatts Workstream (To Do)
13
Lightening - This is the title for my new Jira bug!
DELO-35
Lightening - This is the title for my new Jira bug!
To Do
To Do
DELO-35 Lightening - This is the title for my new Jira bug! (To Do)
14
This is the title for my new JIRA bug
DELO-34
This is the title for my new JIRA bug
To Do
To Do
DELO-34 This is the title for my new JIRA bug (To Do)
There are no rows in this table

Convert important fields, continued
8
Assignee from Jira
Assignee - Convert To Text
Priority
Priority - To Text
Original Start Date
Start Date - Usable Date Format
1
Jamie Fall
Jamie Fall
Medium
Medium
2
Jamie Fall
Jamie Fall
High
High
3
Jamie Fall
Jamie Fall
Medium
Medium
4
Jamie Fall
Jamie Fall
Medium
Medium
5
Jamie Fall
Jamie Fall
High
High
6
John Scrugham
John Scrugham
Medium
Medium
7
John Scrugham
John Scrugham
Highest
Highest
6/21/2021
6/21/2021
8
Brian Dwyer
Brian Dwyer
Medium
Medium
7/22/2021
7/22/2021
9
Jamie Fall
Jamie Fall
Medium
Medium
7/27/2021
7/27/2021
10
Brian Dwyer
Brian Dwyer
High
High
7/5/2021
7/5/2021
11
Jamie Fall
Jamie Fall
Low
Low
7/14/2021
7/14/2021
12
Jamie Fall
Jamie Fall
Medium
Medium
7/11/2021
7/11/2021
13
Coda
Coda
Medium
Medium
14
Coda
Coda
Medium
Medium
There are no rows in this table

Get started

Get started on your own Coda doc with Jira by copying this doc!
Copy doc

Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.