Manufacturing
Quality Inspections, Production Tracking, Defect Management
THE PROMPT
“I run a manufacturing plant with 3 production lines. I need station-by-station quality checks, defect logging with photos, production batch tracking, SPC data collection, and automated non-conformance reports.”
Lattice builds the complete system from this single prompt: 5 entities, 62+ fields, 6 automations.
Data Schema
(5 entities, 62 fields)| Field | Type | Required |
|---|---|---|
| Inspection ID | Auto-ID (QI-####) | |
| Batch | Relation → Production Batches | |
| Station | Select[Incoming, In-Process S1, In-Process S2, In-Process S3, Final, Outgoing] | |
| Inspector | Relation → Operators | |
| Sample Size | Number | |
| Measurement 1 | Number | — |
| Measurement 2 | Number | — |
| Measurement 3 | Number | — |
| Within Spec | Select[Yes, No, Marginal] | |
| Visual Check | Select[Pass, Fail] | |
| Functional Test | Select[Pass, Fail, N/A] | |
| Result | Select[Accept, Reject, Hold for Review] | |
| Photos | Images (multi) | — |
| Notes | Long Text | — |
| Date | DateTime (auto) |
Automations
(6 rules)When Inspection result → "Reject"
When Defect severity → "Critical"
When Batch status → "Released"
When measurement outside tolerance
When Batch QR code scanned
End of shift
Available Views
Sample Workflow: In-Process Quality Check
QC inspector scans batch QR at Station 2
→ Batch BAT-0847 loaded: Widget Assembly, Line 2, 500 units
Inspector pulls 5-piece sample, measures dimensions
→ Measurements: 25.02, 25.01, 25.03, 24.98, 25.05 mm (spec: 25.00 ±0.10)
Visual and functional checks completed
→ All pass — inspection result: Accept
Inspection submitted
→ SPC chart updated, data point within control limits
Next inspection: measurement reads 25.12 (out of spec)
→ Auto-alert: out-of-spec measurement, defect record created
Line lead investigates, finds tool wear
→ Tool replaced, batch placed on hold, 20 units flagged for re-inspection