I’m working on an enhancement for my chicken inventory app to track egg incubation through maturity. Here’s what I’m trying to achieve:
- Batch Table: Stores BatchID, SetDate, and other batch-level details.
- Eggs Table: Stores details of individual egg groups (usually 4–6 per batch), including EggID, fertility rate, and hatch rate.
Goal: Create a single form that lets users:
- Create a new batch (saving to the Batch table).
- Add multiple egg groups (saving each to the Eggs table) with their fertility/hatch rates, linked to the same BatchID.
Question: How can I design this in Glide? Ideally, users would fill out batch info first, then add egg group details in the same form—without needing multiple submissions.
I’ve considered:
- Using a form with a repeating section for egg groups.
- Using actions to update both tables after submission.
- Relationships between tables (e.g., Eggs linked to Batch via BatchID).
Has anyone built something similar? Any tips on structuring the tables or configuring the form would be amazing!
Thanks
Rommel