Construction
Site Daily Logs & Safety
THE PROMPT
“I need to track daily site logs for construction projects. Weather conditions, crew attendance, work completed, equipment used, safety checklists, and progress photos. Auto-send reports to stakeholders.”
Lattice builds: 5 entities, 70+ fields, 6 automations, 7 views.
Data Schema
(5 entities, 67 fields)| Field | Type | Required |
|---|---|---|
| Log ID | Auto-ID (LOG-####) | |
| Date | Date | |
| Project | Relation → Projects | |
| Submitted By | User (auto) | |
| Weather | Select[Clear, Partly Cloudy, Overcast, Rain, Snow, Extreme Heat, Extreme Cold] | |
| Temperature High | Number | — |
| Temperature Low | Number | — |
| Wind Conditions | Select[Calm, Light, Moderate, Strong, Hazardous] | — |
| Crew Present | Relation → Crew (multi) | |
| Crew Count | Number (auto-count) | |
| Subcontractors | Multi-Select[Electrical, Plumbing, HVAC, Concrete, Steel, Roofing, Drywall] | — |
| Work Completed | Long Text | |
| Work Planned Tomorrow | Long Text | — |
| Equipment Used | Relation → Equipment (multi) | — |
| Materials Delivered | Long Text | — |
| Issues/Delays | Long Text | — |
| Safety Checklist | Checklist • PPE compliance checked• Site secured• First aid kit stocked• Fire extinguisher accessible• Scaffolding inspected• Electrical grounded• Trenches shored | |
| Safety Incidents | Long Text | — |
| Progress Photos | Images (multi) | |
| Visitors | Long Text | — |
| Status | Select[Draft, Submitted, Reviewed] |
Automations
(6 rules)When Daily Log submitted
When Safety Checklist has unchecked items
When Issues/Delays field is not empty
Daily at 6 PM (if no log submitted)
When Safety Incident created
When Equipment inspection due within 7 days
Available Views
Sample Workflow: Daily Site Log
Foreman opens mobile app at site
→ GPS confirms location, date auto-filled
Records weather: Clear, 72°F, calm wind
→ Weather data saved
Checks in crew members (tap names)
→ 8 workers marked present
Documents work completed
→ Framing 80% complete, electrical rough-in started
Takes progress photos from 4 angles
→ 4 photos uploaded with GPS tags
Completes safety checklist (all items)
→ All 7 items checked ✓
Submits daily log
→ PDF generated, emailed to PM + Client