Airtable automation actions: Jira Cloud
  • 19 Jan 2024
  • 6 Minutes to read
  • Dark
    Light
  • PDF

Airtable automation actions: Jira Cloud

  • Dark
    Light
  • PDF

Article Summary

As part Airtable’s list of Automations actions, Business and Enterprise Scale users can employ Jira Cloud automation actions. These automation actions allow you to either create or update an issue in Jira Cloud. If your organization uses Jira Server (On-Prem) then check out the documentation for those actions here.

Note

If you or your IT team need more information concerning OAuth scopes and the security relating to how we interact with Jira's API, then please check out the relevant section in this article.

Introduction

Plan availability

Business and Enterprise Scale with varying limitations

Permissions

  • Owners/Creators - Create, delete, duplicate, configure, or rename an automation and edit an automation's description.

  • Editors - View an automation's configuration or copy an automation's URL.

Platform(s)

Web/Browser, Mac app, and Windows app 

Related reading

Creating an automation - Learn how to set up your first automation in Airtable.

Setting up Jira Cloud actions

Note

As a prerequisite, you will need to have both an existing Jira Cloud account and a Jira Cloud instance.

Step 1: General automation setup

Follow the steps outlined in this support article.

Step 2: Choose a trigger

For either of the Jira Cloud actions, you’ll need to set up the trigger that will tell the automation when to run and which record to use to either update or create a Jira issue.

  • For this example, we’ll be using a table we created to keep track of user-submitted bugs. Our ideal workflow is when a new record enters our New Bugs view it will automatically create a Jira issue with the same information.

  • We will use the “When record enters a view” trigger to ensure that any record that enters this view will trigger our new Automation.

  • Next, you’ll choose the Jira Cloud action that best suits your use case

Step 3 (Option 1): Creating a new Jira Issue using the “Create issue” action

  • After your trigger is configured and tested, you can start configuring a Jira Cloud action.

  • You’ll be prompted to select or connect your Jira account.

  • Once your account is connected, the dropdown options for Site, Project, and Issue Type will be pre-populated based on your Jira account. Click the dropdown menus and select the appropriate option for your use case. For our example automation, we’ll use the “Bug” Issue type.

After this initial account configuration is set, you can then customize the details for the new Jira issue you’ll be creating. The fields you can customize include:

  • Summary

  • Description

  • Labels

  • Reporter (contingent on your Jira account permissions)

  • Assignee (contingent on your Jira account permissions)

  • Status

  • Other Issue Data - The subfields listed under the “Other Issue Data” input will allow you to configure custom fields for the currently selected issue type.

For our bug tracking example, we set up the below configuration for our new Jira issue.

1500006889062image5.png

After configuring the action’s options, we’ll run a test to ensure everything is set up properly so far. You can see more information about the test, and your newly created Jira issue, by clicking on the arrow to the right of the test status.

NOTE

When the “Jira Cloud: Create issue” action is successfully run it will automatically return the newly created Jira Issue ID as well as the Jira Issue Key. Learn more about using the Issue ID in other automation steps below.

Step 4 (Option 2): Updating an existing Jira Issue using the “Update Issue” action

  • After your trigger is configured and tested, you can start configuring a Jira Cloud action.

  • You’ll be prompted to select or connect your Jira account.

  • Watch a 100-second walkthrough

  • In order to set up the “Jira Cloud Update Issue” action, you will need to have the Jira Issue IDs for the issues you are looking to update. You can either track these in an Airtable field manually or utilize the IDs captured in an earlier step of the automation as described below.

Here is the trigger we’ll be for this new automation using our previous bug tracking example:

6615674956439whenrecordupdatedtriggerconfigbugtemplate.jpg

You’ll want to ensure that any updates to the table are reflected in the Jira issue we just made. Once the trigger is set up, we can create our “Jira: Update Issue” action. The initial configuration steps are very similar to the steps we took when creating a new Jira issue. You’ll need to select the Jira Account, Site, and Project you’d like to update.

1500006889082image7.png

Choosing an “Issue Type” for updating an existing Jira Issue is optional, but will give you access to any type-specific fields.

You’ll then need to enter the Jira Issue ID or Key that you’d like to update. This is where we will utilize the Jira Issue ID field we previously created on our example table.

Next, you can go about picking the fields you’d like to update on the Jira issue from the prefilled list.

1500007074981image14.gif

Note

If you choose a field to update but don’t fill it with a value, then that field will be cleared out in the related Jira Issue.

Step 5: Test and enable the automation

The last step, as always, is to test your new automation to ensure everything is configured correctly before turning your new automation on. In our example of utilizing both Jira actions in an automation, turning on the automation and adding a new record to the table will now create a corresponding Jira issue and will update our record with the ID of that issue.

1500007074901image10.gif

As updates are made in Airtable to the individual Issue’s record, the automation will additionally update the Issue in Jira.

Capturing the ID of a created Jira issue

A reference to the Jira Issue ID is necessary for the “Jira Cloud: Update issue” action.

  • If you plan to create an automation to update Jira issues at any point in the future we strongly recommend creating a separate field on your table to keep track of the Jira Issue ID for any newly created Jira issues.

  • For our example, we know we want to save the newly created Jira issue ID so we will add one more action to this automation. The below action will update the record that initially kicked off this automation by capturing the returned ID for our new Jira issue in the “Jira Issue Id” field on the table.

    6615674649879updaterecordactionconfigjiratriggersexample.jpg


FAQs

What if I have Jira Server (self-hosted / on-site)?

Jira Server automation actions are covered in this support article.

Do the Jira automation actions support custom fields?

Yes, but only string (text), single select, and multiple select fields. Some types of custom fields, particularly those that come from plugins, may not be supported.

Can I use a Jira action to create sub-tasks in Jira?

Neither of Airtable’s Jira Cloud automation actions supports creating sub-tasks.

Can I use a Jira action to link Jira issues to one another?

We support linking an issue to a parent issue, but other types of issue links are not supported.

How do I use multiple JIRA sites?

To connect to another Jira site, you can select “Connect new account” from the account selection menu, and select the desired site as part of the authorization process.

How do I connect multiple Atlassian / Jira accounts?

This is a bit more complicated due to the Jira account authorization process. To add a second Jira account, you have to first log out of Atlassian in the same browser. Then, select Connect new account from the account selection menu and log in via the desired Atlassian account.

What happens to automations that include a Jira Cloud action if the connected Jira account gets deactivated?

If the Jira account for a related automation is deactivated or disconnected, then the automation will cease to work until a new Jira account is connected and configured.

Why are there no choices available for the “Reporter” dropdown?

The selected project and issue type in Jira does not allow the “Reporter” field to be set. More context from a Jira community post here.

Are attachment fields supported?

No. However, one workaround would be to use a custom text field for an attachment URL, so that the attachment can be accessed from or referenced in Airtable.


Was this article helpful?