Automation: Remove label that was added

[Chase Schwalbach]

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:

1. 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 "-"
2. I need the automation to recognize this, which I can do with the below smart field in the image

1. 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?
2. Question 2: Next, I want to remove the label. So just whatever labels have "coda-sprint-change" in them, remove those labels

[Chase Schwalbach · Accepted solution]

Hi, 

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

1. 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
2. Use that in the label "coda-sprint-change-592" for example
3. Then edit with

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

1. 

[Trudy Claspill]

Awesome!

[Trudy 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.

[Chase Schwalbach]

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"