Hello, I'm using some integrations with Coda.io on JIRA, and one of those is going to be used to "Change a sprint" in JIRA. Unfortunately the integration kind of sucks, so I've come up with this idea using labels, which I can change with the integration easily. It's easy to set up a label to trigger automation to move to the Backlog. The automations will move them to the backlog and still be tagged to the correct Board (we have multiple boards driven by a custom field for each team). But when I want to move to a specific board, say "DevOps Sprint 8" or "Platform Sprint 7," is where I come up with issues. Steps: * I'll automatically set a new label for the issue, "coda-sprint-change-to-DevOps Sprint 7" -- I'll be able to add a label dynamically that includes a name of a new sprint as the last piece of text after the last "-" * I need the automation to recognize this, which I can do with the below smart field in the image * Question 1: Then I need to actually change the sprint to this value. I have no idea how to do this with smart fields? Imagine I'd have the name of the sprint, but not the ID. So I'd have "coda-sprint-change-to-DevOps Sprint 8" of which the Sprint Name is "DevOps Sprint 8" -- how can I split by "-" and get the text "DevOps Sprint 8" and then set the Sprint with the title vs the key of the sprint? * Question 2: Next, I want to remove the label. So just whatever labels have "coda-sprint-change" in them, remove those labels

Hi, I was able to solve this. Specifically, I had to: * Add a "Sprint ID" custom field that is set by automation, so that when I grab JIRA tickets in Coda I am able to get the Sprint ID * Use that in the label "coda-sprint-change-592" for example * Then edit with { "update": { "labels": [{ "remove": "{{varLabelIterate}}" }] }, "fields": { "sprint": {{varLabelIterate.split("-").last.asNumber}} } } *

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automation: Remove label that was added

Chase Schwalbach_rfeaa9

Hello,

I'm using some integrations with Coda.io on JIRA, and one of those is going to be used to "Change a sprint" in JIRA. Unfortunately the integration kind of sucks, so I've come up with this idea using labels, which I can change with the integration easily. It's easy to set up a label to trigger automation to move to the Backlog. The automations will move them to the backlog and still be tagged to the correct Board (we have multiple boards driven by a custom field for each team). But when I want to move to a specific board, say "DevOps Sprint 8" or "Platform Sprint 7," is where I come up with issues.

Steps:

I'll automatically set a new label for the issue, "coda-sprint-change-to-DevOps Sprint 7" -- I'll be able to add a label dynamically that includes a name of a new sprint as the last piece of text after the last "-"
I need the automation to recognize this, which I can do with the below smart field in the image

ChaseScreenshot 2023-04-20 at 17.20.55@2x.png

Question 1: Then I need to actually change the sprint to this value. I have no idea how to do this with smart fields? Imagine I'd have the name of the sprint, but not the ID. So I'd have "coda-sprint-change-to-DevOps Sprint 8" of which the Sprint Name is "DevOps Sprint 8" -- how can I split by "-" and get the text "DevOps Sprint 8" and then set the Sprint with the title vs the key of the sprint?
Question 2: Next, I want to remove the label. So just whatever labels have "coda-sprint-change" in them, remove those labels

Accepted answers

Chase Schwalbach_rfeaa9

Hi,

I was able to solve this. Specifically, I had to:

Add a "Sprint ID" custom field that is set by automation, so that when I grab JIRA tickets in Coda I am able to get the Sprint ID
Use that in the label "coda-sprint-change-592" for example
Then edit with

{
"update": {
"labels": [{
"remove": "{{varLabelIterate}}"
}]
},
"fields": {
"sprint": {{varLabelIterate.split("-").last.asNumber}}
}
}

All comments

Trudy P Claspill

Hello @Chase Schwalbach

Welcome to the Atlassian community!

I'm still thinking about your first question.

Regarding your second question, yes you can remove 1..n values from the Labels field.

Use the Edit Action. Select the Labels field as the one you want to Edit. Next to the data field click the ... button and select ADDREMOVE. That will give you two fields; one for specifying Label values you want to add, and one for specifying Label values you want to remove.

Screen Shot 2023-04-21 at 12.35.58 AM.png

Chase Schwalbach_rfeaa9

Hey, but the system wouldn't know what the label is ahead of time. So I'd need to intake that from the trigger to know if I'm removing "coda-sprint-change-to-DevOps Sprint 8" or "coda-sprint-change-to-Platform Sprint 8"

Chase Schwalbach_rfeaa9

Hi,

I was able to solve this. Specifically, I had to:

Add a "Sprint ID" custom field that is set by automation, so that when I grab JIRA tickets in Coda I am able to get the Sprint ID
Use that in the label "coda-sprint-change-592" for example
Then edit with

{
"update": {
"labels": [{
"remove": "{{varLabelIterate}}"
}]
},
"fields": {
"sprint": {{varLabelIterate.split("-").last.asNumber}}
}
}

Trudy P Claspill

Awesome!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud