List days capacity between two dates
I'm trying to calculate the workload of my department while adding new projects. So I have a table for Projects submitted and a table of employees' availability dates. I need a formula that does th...
Forum Discussion
-------------
There is a real advantage to a scripted solution which is that you will get a static value that you can store when the Project is created or evaluated. A pure Quick Base solution where things are dynamically calculated will change as the Days Capacity change.
--------------
Having it dynamically calculated and updated is not gonna be a problem at all, I can find a workaround to store the "state" of the project at the time of submission.
(Checkbox to be ticked while adding a new project confirming our knowledge that we might not meet due date for example)
So a pure Quick base solution can still be an option.
Thank you for your help.
------------------------------
Karim Gawish
------------------------------
There is a real advantage to a scripted solution which is that you will get a static value that you can store when the Project is created or evaluated. A pure Quick Base solution where things are dynamically calculated will change as the Days Capacity change.
--------------
Having it dynamically calculated and updated is not gonna be a problem at all, I can find a workaround to store the "state" of the project at the time of submission.
(Checkbox to be ticked while adding a new project confirming our knowledge that we might not meet due date for example)
So a pure Quick base solution can still be an option.
Thank you for your help.
------------------------------
Karim Gawish
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendMy native solution is to create a middle table called Project Day Assignments
1 Project has many Project Day Assignments
1 Capacity has many project day Assignments.
That will allow you to summarize up to capacity to see where you have unused or overused capacity.
I would first get this working manually, and then we can discuss ways to make the process of adding the assignment records more easily. A stating point is that for the drop down record to choose a capacity day to assign a qty to, to filer the drop down report for only where there is some capacity remaining.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
1 Project has many Project Day Assignments
1 Capacity has many project day Assignments.
That will allow you to summarize up to capacity to see where you have unused or overused capacity.
I would first get this working manually, and then we can discuss ways to make the process of adding the assignment records more easily. A stating point is that for the drop down record to choose a capacity day to assign a qty to, to filer the drop down report for only where there is some capacity remaining.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------