Hoping with a little help to know whether my solution is headed in the right direction. I’m trying to separate records throughout my app - but the Bubble method of record relations is not all that clear to me.
The application is meant to allow users to create a Job/Task and then update the task with outputs/parts completed. Each job runs across three shifts and each shift has multiple outputs.
Job A has 9000 parts that need to be completed across multiple days.
Job A has a day shift that contributes 1000 parts on Day 1
Job A has a night shift that contributes 2000 parts on Day 1.
Total parts complete for Day 1 are 3000 [1000 from shift days and 2000 from shift nights]
The users would like to see the total parts being completed as well as the parts being completed by each shift.
Current Database setup:
Job [Parent Data]
Output Per Day [Child Data]
Job Data Type
Has a connection to Outputs and is set up as a list. The primary field for this is the # of pieces completed to help track how many pieces are done.
Output Data type
Has fields like #of pieces completed, shift, time/date.
I’m able to capture the number of pieces from the child record into the parent record - screenshot is of the parent record showing individual output numbers but not which shift has submitted these.
How do I set up the database to show that :
Day 1: Day shift contributed 200 pieces
Day 1: Night Shift contributed 450 pieces
Day 2: Day Shift contributed 100 pieces.
Day 2: Night shift contribution 50 pieces.
Is it another data type I have to include?
Job [Parent] ← Output Per Day [Child] ← Outputs Per Shift [Grand Child]
Or another connection that goes from Child to Parent?
Currently only have Parent to Child as a list.