Is there is any customfield type which was calculated and editable at the same time?

[Begoña Bonet]

Hi, my question is focused to solve the problem described in this question: https://answers.atlassian.com/questions/87287

Thanks in advance

Begoña

[Nic Brough -Adaptavist- · Accepted solution]

No, you can't have a calculated and editable field, it's a nonsense - either you want to calculate it, or you want the user to enter it, one option will always destroy the other.

I can see a use for two separate fields tied together.  A calculated one that displays something, and then an editable one that, at some point in your workflow, is pre-populated from the same calculation the calculated field uses, and then allows the user to edit it.  A bit of scripting should do that.

[Begoña Bonet]

Hi Nic, I agree with you on that is seems not to have sense but, I need to calculate the initial value of a customfield. I've thought in the solution proposed by you in the second parragraf but the problem is.....How can I do in the creation issue to propose an initial value to the users? I have no idea about copying the calculated value into the other editable customfield.....

[Nic Brough -Adaptavist-]

That's a different story again. You're wanting to pre-populate a field with a calculation before you have any data for it. That's what defaults are for really. But they're not very flexible. Could you explain what you are trying to do?

[Begoña Bonet]

Yes Nic, I need to create issues with at least 2 customfields: a) A customfield named "Software Element". b) A customfield named "Internal Code" that must meet the following format: Software_Element_value.XXX where XXX are digits c) For the first issue related with an specific "Software Element", I need to propose for "Internal Code" customfield the initial value Software_Element_value.001 Example: PISCIS.001 d) The user must be able to modify this internal code but meeting the right input format. For example: PISCIS.025 is ok e) For the second, thirdh and more issues created and related with the same specific "Software Element", I need to propose for the "Internal Code" customfield the next initial value: Software_Element_value.max(XXX) For example: PISCIS.026 f) Again the user can act the same as in point d) I know this can sound crazy, but I need to reproduce exactly this management of internal codes using JIRA (or at least I need to try it).

[Nic Brough -Adaptavist-]

Right, that's pretty complex, and it's going to be very hard to kludge into Jira using scripts. This is the sort of thing where I'd be reaching for proper plugin development, unless you're willing to change the approach a bit. To avoid coding, I would - Create "software element" as a single select list - Create a number field for "element" - Create a scripted field for "suggested element" which will display above the "element" field on the create screen - the script will need to execute some search for the highest value of "element" Now, when the user clicks "create", I would - Have a validator check the number they have entered - In a post-function, if they have left the element field empty, do the same calculation the "suggested element" field has done and put that in element automatically. Finally, - do not put the "element" field on the view screen - have a second scripted field that concatenates "software element" with "element" and displays that where required

[Begoña Bonet]

Ok, I like this solution but, one more doubt: I've tried to use SIL Customfield for showing the propose value but this kind of customfield isn't shown in the Creation and Edition screens. Which type of customfield need I to use? Is Scripted customfield type suitable for doing that? I mean, it's shown in the creation screen? Thanks a lot Begoña

[Nic Brough -Adaptavist-]

Ah, I've not really used SIL much, I've always reached for the "script runner" calculated fields. I think that can do create screen fields.

[Begoña Bonet]

I've just tried using "Scripted Field" for "element" customfield and it happens the same: it isn't shown in Creation and Edition screens, it's shown only in View screen...... Any idea? Begoña

[Nic Brough -Adaptavist-]

Ack, rats. I've made a mistake - I thought the scripted fields could come out on "enter data" type screens, but they don't, they only work on "show data" type screens. I can't think of a way to do any of this without some coding. It is possible to put display-only fields on to a show-data screen. I know I've done it - you need to define a template for show and another for update in the plugin and I've used a template that simply doesn't have any input on it, just a data display. But you'll notice I said "plugin" there - because I had to do it in code.

[Begoña Bonet]

My last test..... without success..... I've created a Scripted Customfield with the next groovy code: import com.atlassian.jira.component.ComponentAccessor; import com.atlassian.jira.issue.CustomFieldManager; import com.atlassian.jira.issue.fields.CustomField import com.atlassian.jira.issue.Issue; import com.atlassian.jira.issue.IssueManager // MANAGERS CustomFieldManager customFieldManager = ComponentAccessor.getCustomFieldManager(); IssueManager issueManager = componentManager.getIssueManager() Issue mIssue = issue INTERNAL_CODE = "Internal Code" CustomField customField_internal_code = customFieldManager.getCustomFieldObjectByName(INTERNAL_CODE) def text="PISCIS.CFG.001.000" mIssue.setCustomFieldValue(customField_internal_code, text); return text

[Begoña Bonet]

Because Scripted Fields and SIL fields aren't shown in Create/Edit screens, finally I've used: Database Information customfield to propose the new Internal Code + Behaviour to make this field readonly + An editable customfield that allows the users to input the final Internal Code Thanks a lot!! Begoña