Managing Construction Projects

[Oluwole Fapohunda]

I am looking to find out if it is possible to manage construction projects using Jira Work Management. 

In my use case we have a bill of quantity (BOQ) with resources (human and material) with fields such as quantity, rate, amount etc currently managed with excel. 

Will it be possible to upload this BOQ in a Jira project, such that the project tasks can be tracked against the original BOQ.  For example assuming I have 1,000 paint buckets for the project, for a particular painting task I should be able to indicate that 10 paint buckets were used, just the same way time can be logged and it will deplete from the 1000 defined for the project. needless to say that the task could potentially have more than one resource, for instance I will want to be able to also enter the about of human resource that was expended in the same painting task.

Based on this I should be able to create dashboards that can show progress based on time and material.

I am open to potential solutions even if it will require purchasing multiple plugins.

Thank you. 

[John Funk · Accepted solution]

Hi @Oluwole Fapohunda 

You could probably do this, though it might be a little clunky. You could have a couple of separate custom field that has the current balance of your resource.

So that balance starts with 1,000 buckets of paint. 

Then you have a separate custom field that contains the number of buckets of paint for a particular project -say 20. 

Then when you complete or assign buckets of paint to a project, it subtracts the total from the overall balance. You would do that using automation for Jira rules.

It's not as clean as using Insights, but would be a whole lot cheaper in that you wouldn't need additional add-ons. 

[Mark Segall · Accepted solution]

Hi @Oluwole Fapohunda - It sounds like you need a combination of issue tracking coupled with a database for tracking your supplies.  Work Management would absolutely be able to handle the task tracking needs.

To get the database aspects, you'd want something like Insight which is only available with Jira Service Management (JSM) premium licensing.  Insight would allow you to capture your inventory and other resource data. Then you would leverage automation to be able to deplete inventory as issues are linked to Insight objects.

[Oluwole Fapohunda]

HI @Mark Segall @John Funk I am trying the solution using Insights from JSM.

I have created the object schema with various object types (resources such as roofing, painting, concrete etc) under each object type there are different objects which correspond to a specific brand of say paint. What I am looking to achieve is to create a custom field on the project ticket that will allow a user select which type of resource (object type), the brand (object) and input a quantity in another filed that will be used to complete that task. When that ticket makes the done transition an automation rule will subtract the quantity entered against the quantity attribute of the specific object that was selected from the ticket.

I am not quite sure how to set up the object selection from the ticket fields and also how to capture that input in the automation rule to perform the resource depletion.

This is a sample of the depletion mathematical expression but I do not know how to modify it to support receiving the input to identify the specific object to be depleted considering there are multiple object types and multiple objects

 {{#=}}{{object.Quantity}} - {{issue.customfield_10066}}{{/}}

Any advise will be appreciated.

Thank you

[Mark Segall]

Hi @Oluwole Fapohunda

Here's a solution that is really for a simple scenario... I have a starting number and a ticket needs to change that number.  If you want something more complex like say, I want to go back and update the quantity in my request after submission because I got it wrong, you're looking at needing to change your architecture.  

INSIGHT ARCHITECTURE

Make sure your brand object has a reference attribute back to the resources object.  You'll need this in the second custom field below.

CUSTOM FIELD #1 - Resource

This is an insight field and you'll need to set up the context.  The main thing is the Filter Scope which would be:

 objectType = resources

CUSTOM FIELD #2 - Brand

Also an insight field.  Two aspects of this one...

• Filter Scope

  • objectType = brands

• Filter Issue Scope (you'll need the customfield ID from Your Resource field)

  • ${customfield_xxxxx} 

CUSTOM FIELD #3 - Quantity

Looks like you already have this, but just verifying

AUTOMATION - Deplete stock

• TRIGGER: Issue Created
• ACTION: Edit Insight Field Attributes (Brand Field)
  • Quantity attribute
  •  {{#=}}{{object.Quantity}} - {{issue.yourQuantityField}}{{/}}