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 s...
Forum Discussion
This is a big process to get this, but the cliff notes version is;
You will want to have a Task table, a Template Task table, and a Project Type table.
Basically you will want to have a template list of tasks for the project, based on the project type.
The reason you break this up is multi faceted, but some of the reasons can include, different lists dependent region of task, client requirements, details with equipment, or general changes in process over time.
When you make a new project, and pick the project type, a script will then load the most recent and applicable task list.
Yes, over time it could be a lot of records, but the tasks are very minimal information, and all of that info is connected to the project and the task driven status.
You will want to have a Task table, a Template Task table, and a Project Type table.
Basically you will want to have a template list of tasks for the project, based on the project type.
The reason you break this up is multi faceted, but some of the reasons can include, different lists dependent region of task, client requirements, details with equipment, or general changes in process over time.
When you make a new project, and pick the project type, a script will then load the most recent and applicable task list.
Yes, over time it could be a lot of records, but the tasks are very minimal information, and all of that info is connected to the project and the task driven status.
Bonus;
What if you have dependancies. i.e. You can't start task 4, until 1 & 2 are done, but you can start 3 when 1 is done. or any other workflow needs.
This allows you to set those up and have actual real life start and end dates for your 'task management'
What if you have dependancies. i.e. You can't start task 4, until 1 & 2 are done, but you can start 3 when 1 is done. or any other workflow needs.
This allows you to set those up and have actual real life start and end dates for your 'task management'