It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Is a rolling budget field possible?

my company wants to manage their orders in jira. They want to have the parent issue contain a total budget and all the child tickets contain their costs which subtract from the total budget in the epic. Is this even remotely possible?

4 answers

Hi @Scott Federman,

You can do this using the Power Scripts add-on.

There is a video tutorial walking you through in detail here, and we've also posted a short, sample script you can copy and paste or forward to your engineer.

Hope this helps!

Johnson

@Johnson Wang

 

That was very helpful! Can this be used on other issue types like story as opposed to sub-tasks?

 

Scott

@Scott Federmanglad to hear it was hopeful :)

Yes, you can definitely modify this script so that it can be used between other issue types aside from just sub-tasks.

Hand the short script over to any engineer and they'll be able to quickly make the changes to the customfield IDs and logic for you.

0 votes

Yes, it is possible if you have a plugin like Adaptivist Scriptrunner or similair. In Scriptrunner you could create a scripted field which would make the calculations.

Thank you Alexey

Thats great news! I unfortunately am not a programmer and totally illiterate when it comes to writing scripts. Could you give me an example to work from? It would be simple subtraction.

Hey All, 

 

Still having some issues getting the rolling budget to work. Would anyone be able to possibly show my what script will work for this? Here is the set up. 

 

Issue Types: 

  • Project Budget
  • Order Request

Custom Fields

  • Budget (Project Budget)
  • Remaining Budget (Project Budget)
  • Expense (Order Request)

Link Type: Relates To

Function: Budget-Expense = Remaining Budget

Scenario: A project budget is entered into the budget field in the project budget issue type. Expenses are entered into the Expense field in the Order request issue type and then linked to the project budget using the relates to link type. The Remaining budget field is calculated and returned based on the expense being subtracted from the budget.

@Scott Federmandid you try this using the Power Scripts add-on, and following the video we recorded?

It should have addressed this exact use case for you, but let me know where you're still having challenges.

Hi Johnson, 

 

It addressed the issue whereas the child is a subtask.  I am not using subtask however. It is a custom issue type of order request which is linked by "is related to". This will allow the user to create orders from the create screen instead of going into the "parent" issue and creating a subtask type which will eliminate a step for the user. 

 

I unfortunately dont have anyone who can help me script this function so any direction you could provide would be massively helpful.

@Scott Federman if you would like assistance writing this script I would be happy to help. Just let me know.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Software

Early Access: If you use Jenkins and Jira Software Cloud, you need to read this!

The Jira Software Cloud Team has been busy working on a simple, secure, and reliable way to integrate your build and deployment information from Jenkins with Jira Software Cloud. This means you don’t...

2,079 views 2 18
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you