How can I assigning multiple team members to 1 project?

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

Hi there. I am looking for a way to assign multiple team members to 1 or multiple projects. Is this possible? If so, how would I do it? I am looking to do this so that we can see what our resource allocation is and report on area's of overlap.

Thanks for your help,

Mark

Photo of Mark

Mark

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
Can you describe your table setup now and their relationships.
Photo of Mark

Mark

  • 0 Points
Hi there. I am using the Quickbase Team Project Template App and modifying it to suit our needs. I hope that helps
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
Hmm, no really, since I would have to take the time to download that app to see how it was built.  Maybe I will have a chance later.
Photo of CloudBaseServices

CloudBaseServices, Champion

  • 0 Points
Mark -

CloudBase Services recommends creating a table called "Assignments".  There would be (at least) 2 fields in the Assignments table: a team member AND a project.  The team member would be populated from a People table. (One team member (aka person)  can have many assignments.).  The project would would be populated from the project table. (One project can have many team members.)  You can add other fields to the Assignments table to track workload.

Resource allocation is more complex to set up.  Here is a video showing how our firm does it:  https://www.youtube.com/watch?v=PwqcTqDamAM