LinkedIn
Twitter
Hy everyone,
I have a bit of a tricky request, but I’m about to jump in something a bit over my head and I am hoping for some structure/guidelines advice 
I am making a Task Management app for my little Custom Furniture Production workshop.
So every Project has multiple tasks.
Every task is carried out by multiple people AND every task may include multiple operations - welding, grinding, cutting, cnc, sanding, assembly, painting etc.
And I want at the end of the day for everyone to complete a fast form (or edit on each task) how many hours he spent on the task, doing what kind of operation.
The goal would be that in the end, I can get a report on a task, showing a list (or table I guess) of who spent how many hours doing what operations.
I’m hoping the report could look something like this:
Project 1.
Task A
Member A
- Welding - 2 hours
- Grinding - 1 hour
Member B
- Cutting - 3 hours
- Assembly - 2 hours
Member C
- Assembly 2 hours
Task B
Member A
- CNC - 2 hours
Task C
Member C
- Painting - 4 hours
Member A
- Finnish - 1 hour
- Packaging - 1 hour
And of course, the main goal is to make the filling in procedure of the hours spent, as user friendly and as fast as possible (time tracking won’t work in production. a fine guess at the end of the day is good enough)
Any advice on how I can make this happen?
I guess lists will be involved but I haven’t used them yet. And can a list hold three separate items?
(if the task contains a list that holds groups of three - member name, type of production and number of hours, where each can be accessed separately, as later on I would also need to only get the total number of hours spent on what kind of operation, regardless of who worked on them)
Or maybe something else that I don’t know about yet but can’t wait to find out?
You know of any apps that do something similar, for me to look under their hood?
Thank you so much,
Sorin
