Forum Discussion

MichaelBretton's avatar
MichaelBretton
Qrew Member
5 years ago

Capacity/bandwidth planning?

Hi all, Just wondering whether anyone has used their Quickbase apps for team bandwidth/capacity planning? I just can't picture how I need to build this despite knowing what I need. The use case...
App builders
MichaelBretton's avatar
MichaelBretton
Qrew Member
5 years ago
Hi Blake,

Thanks for your reply - No, I don't think I need to drill into the specific in-depth details of a person's schedule like you mention in the second option....I just need to get a handle on their current bandwidth like the first option, but with the capacity levels and project weighting in-line with the table I posted above.

Hope that makes sense?

Thanks,
Michael

BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
I agree with Jen's suggested setup. Taking into account your original list of roles and their points value, it sounds like you may have multiple users/roles assigned to each project. With that in mind, I think a structure like this would be a good starting point:

The Roles table would be where you would define the Role and their associated Points. Project Role would then combine the Role, User, and Project. And the Users table would allow you define their capacity as well as do the summary field Jen mentioned from the Project Roles.

If you don't have the need for multiple Role assignments per Project, then just eliminate the Project Roles table and move the User and Role relationships to the Project directly.


------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------