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.
Helpful!
Can you elaborate more as to how this part is done:
Why have the Template Task Table? Why not have all templated tasks in the Tasks table and then only copy / associate the ones I need based on Project Type?
Can you elaborate more as to how this part is done:
When you make a new project, and pick the project type, a script will then load the most recent and applicable task list.So copy the corresponding templated tasks as new tasks and associate them with the new project?
Why have the Template Task Table? Why not have all templated tasks in the Tasks table and then only copy / associate the ones I need based on Project Type?