Rename a Custom Field based on ID and JQL

Question

Hello everyone. Sorry for my bad english.

I've been dealing with ProForma and Automation for Jira.

The situation is

- Customer fills a form and selects a drop-down menu (number 25, according to ProForma) with certain data. The data is populated from the GLOBAL data from Jira custom field cf_10150 labeled "Position" where all the positions are labeled by their respective names. Let's put "Manager" as "id": "10643" (according to JSON API)

With this, Automation for Jira picks the value "10643" filled by the customer in the proforma based in the smart value

{{issue.properties."proforma.forms.i1".state.answers.25.choices.get(0)}}

and changes the TICKET value for the custom field "Position". The thing is, that instead picking the label from the form, it only takes the field value "10643". I want this to change to the label "Manager" but I haven't found a way to solve it.

I was thinking that maybe based in JQL this can be solved, but tried cascadeOption(10643) and seems like this is not possible with this kind of request. (as suggested in https://community.atlassian.com/t5/Jira-questions/How-do-I-use-the-ID-of-a-Custom-Field-Value-in-JQL/qaq-p/79073)

Any clues in how to go ahead with this?

Thanks in advance and greetings from Chile.

andrewd_n8fmlu · Answer

Hi Felipe,

I am a Support Engineer from ThinkTilt for the ProForma product.

Trying to use smart values from ProForma form data (especially data from choice lists) has been a popular question for us.

We’ve been investigating this further internally and have found that ProForma and Automation-for-Jira smart fields are currently not compatible. This means we’ll have to do some work in this regard because clearly this is a valued feature.

We're sorry for the inconvenience.

That being said, we are currently doing work in another area of ProForma (Form Load & Save) which we believe has a feature with potential to provide you the access to the ProForma form answer data you’re needing. This is in the form of an Answers Array which contains form data answers. If and/or when we could deliver this, you could use this instead for your form data usage.
With that in mind, while we cannot currently provide an immediate timeframe, we have an issue in our backlog. If you like, we can notify when there is an update.

Furthermore, you can keep an eye on our quarterly roadmap for plans for ProForma each quarter. I would also recommend you watch our version history on the Jira Marketplace to be notified of updates.

If you need anything else in terms of ProForma, please feel free to reply or raise a request directly with ProForma.

My apologies again for the inconvenience.

Regards,

Andrew.

Yvan Martin_qxvthw · Answer

Hi Felipe,

I'm not fully sure I understand your scenario. Could you take some screenshots of your current Automation Rule, as well as the field you are trying to view and exactly what information you are trying to pull out?

It may also help to hit the Jira API to see what information is returned from that proforma field, to see what we can access via smart value with Automation. You can do that by hitting an example issue i.e. http://YOUR_INSTANCE_URL/rest/api/2/issue/EXAMPLE_ISSUE_ID_WITH_PROFORMA_FIELD.

Since we don't currently provide deep integration with proforma, it would only be possible if the operation you are trying to do works with common Jira properties and values that we can access. Look for your proforma field in the JSON above and see what values are in the object from that URL. A screenshot of that may help figure out if that's possible.

Cheers.