JoshJosh1
8 years agoQrew Trainee
Managing Project Tasks & Status
Let's say that I have a Projects table with a Status field where each status acts as a state that drives which Role is tasked with working on that project so that the Project can advance to the next state.
For example, a Project may have a status called "Under Review" in which user(s) in the Project Manager role needs to perform a set of tasks or checkpoints on the Project before the status is automatically changed to "In Progress".
What is the recommended way to implement this? Specifically, how should I:
Any advice would be appreciated.
For example, a Project may have a status called "Under Review" in which user(s) in the Project Manager role needs to perform a set of tasks or checkpoints on the Project before the status is automatically changed to "In Progress".
What is the recommended way to implement this? Specifically, how should I:
- Create a set of tasks or checkpoints that must be finished for each Project Status
- Automatically advance the Project Status to the next status once all tasks for that status is complete
- If I create a Tasks table, I don't want to have to duplicate the same tasks for all Projects - that would end up using a lot of space over time given that each Project may have some 50+ Tasks across the different Statuses.
- How to safely advance the Project Status once the criteria for the current project status has been met. I don't want some of roles to be able to just manually toggle the Status of a Project. Advancing the status should be a function of completing all required tasks for that stage.
Any advice would be appreciated.