Tasks with multiple operations carried out by mult...

sorin_mihai · 08-15-2019 08:19 AM

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

LeventK

@sorin_mihai
You need a simple clock in & out for each particular work. Very easy to accomplish actually.

Add 3 columns to your works table: Clock-in, Clock-out and Duration. You can name them as you like. The very first 2 are Timestamp and the last is Duration type. Clear out all the initial values in this columns.
Add 2 actions for this table:
– Clock-In: set as Data: change the value of a column, choose your [Clock-In] and as the value set NOW() expression.
– Clock-Out: set as Data: change the value of a column, choose your [Clock-Out] and as the value set NOW() expression.
Expand your [Duration] column and create an expression like this in AppFormula property:

IFS(
	ISNOTBLANK([Clock-Out]),[Clock-Out] - [Clock-In]
)

You may want to check this sample app as well
https://www.appsheet.com/samples/A-timesheet-app-that-allows-employees-to-log-time-in-and-time-out?a...

sorin_mihai

Hy LeventK,

Thanks for replying.

Like I said, time tracking is not going to work in this type of production 'couse you generally work with gloves or paint or … and in one day you can do 4 types of production on one or more tasks. So timestamps are not practical in this case.

I’m thinking of making another table that on one column references the tasks and where with a form people can just complete how much time they spent on what type of production. So this table will have on each row a task, with a name of a member, a type of production and a number of hours.

Then on the task view, it should show only the entries for that specific task and order them by person…as if the production types are subtasks and people fill these in with the number of hours it took to make them.

I’ll give this a go and be back with details if it works hopefully it’s not so complicated after all

Tasks with multiple operations carried out by multiple people for different number of hours