Prevent Workflow transition if field value entered has duplicate

Question

When a user transitions to a new status, a screen appears that requires the user to enter a unique value for the "Serial Number" text field.

If the user enters a duplicate serial number, I want to prevent the transition, and show an alert (either in the transition screen or on the main screen) that says "You have entered a duplicate serial number".

How can I achieve this, either out of the box, or with a Jira app?

Thanks for your help.

Vicente Domínguez [Decadis AG] · Answer

Hello @Doods Perea and thank you @Ste Wright for mentioning us!

I am part of the Decadis team and, although I think that it is not possible to validate with a JWT for Jira Cloud validator if a serial number was already used in a previous issue with our app, it might be possible to update the new issues automatically with a serial number that was not used before.

If you are interested in this approach and need further assistance, please, feel free to create a request in our Support Portal.

Best regards,

Vicente

Ste Wright · Answer

Hi @Doods Perea

It's not available natively; I'm not sure which Apps would be able to do this - but I'd contact the vendors for Apps such as...

* ScriptRunner for Jira 
* Power Scripts - Jira Workflow Automation 
* JSU Automation Suite for Jira Workflows 
* Jira Misc Workflow Extensions (JMWE) 
* Jira Workflow Toolbox 
* ...or another App from the Marketplace

...and see if they can suggest a method of doing this using their App. Their contact details can be found in each listing's Support tab.

---

I can think of a native workaround, but it's not an ideal user experience. You could use Automation to...

* Check for all issues transitioned to this status (i.e post-transition)
* Clarify if the Serial Number is in use on another issue
* If it is, reverse the transition
* And notify the user (either via email or comment) that the Serial Number is in use and they must choose a unique one

---

Let us know your thoughts!

If you'd like more instructions on how to build the Automation Rule, we'd be happy to help :)

Ste

John Funk · Answer

Hi Doods,

You most certainly will not be able to do that out of the box with Jira. And not sure about any apps that might do that. Maybe ScriptRunner Behaviours.