assign multiple resources, and their estimated hours, to a single task

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I see quite a few responses on how to assign mult resources to one task, but can you also estimate the hours each of those resources may spend on the task?

Example:  Task = Dig hole

Resources:  Bill, Jim, Jane

Hours:  Bill 1, Jim 4, Jane 6.

My app is set up with tables for Projects, Tasks, and Resources.  Many Tasks to One Project.  Many Resources to One Project.  

Photo of J1987

J1987

  • 60 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
Will you have multiple resources assigned to do the same task?
Photo of J1987

J1987

  • 60 Points
Yes
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
Since you want to assign resources to tasks, you will need to build a Resource Assignment table.  This will be the "join" table between Resources and Tasks, since 1 Resource can be assigned to Tasks  but also 1 Task might be assigned to many Resources.  That Resource Assignment Join table is where you can have a field to record the time allocated or spent on that task by each Resource.

So, you will end up breaking the relationship between Resources and Projects as resources will be assigned via that Resource Assignment Table.