Cleaning & Janitorial
Verification & Proof of Service
THE PROMPT
“I manage a cleaning company. Need to verify cleaners arrive on time with NFC check-in, track room-by-room cleaning with checklists, capture before/after photos, and auto-send proof-of-service reports to clients.”
Lattice builds: 6 entities, 85+ fields, 7 automations, 7 views.
Data Schema
(6 entities, 83 fields)| Field | Type | Required |
|---|---|---|
| Log ID | Auto-ID (CLN-######) | |
| Date | Date | |
| Location | Relation → Locations | |
| Cleaner | Relation → Cleaners | |
| Check-in Time | DateTime | |
| Check-out Time | DateTime | — |
| Duration (auto) | Number (minutes) | — |
| NFC Verified | Checkbox | |
| GPS Coordinates | GPS | |
| Room Checklist | Checklist (from Location) | |
| Rooms Completed | Number (auto-count) | — |
| Before Photos | Images (multi) | — |
| After Photos | Images (multi) | |
| Supplies Used | Multi-Select[General Cleaner, Glass Cleaner, Disinfectant, Floor Cleaner, Restroom Supplies, Trash Bags] | — |
| Issues Found | Long Text | — |
| Maintenance Needed | Long Text | — |
| Client Present | Checkbox | — |
| Client Signature | Signature | — |
| Status | Select[In Progress, Completed, Partial, Skipped] | |
| Notes | Long Text | — |
| Rating (from client) | Select[5 - Excellent, 4 - Good, 3 - Average, 2 - Below Average, 1 - Poor] | — |
Automations
(7 rules)When Cleaner checks in via NFC
When Cleaning Log completed
When check-in is late (>15 min after scheduled)
If no check-in within 1hr of scheduled time
When Issues Found field is not empty
Weekly on Sunday
When Quality Inspection score < 7
Available Views
Sample Workflow: Office Cleaning Visit
Cleaner arrives at ABC Corp office
→ Taps NFC tag at entrance
System verifies NFC + captures GPS
→ Check-in logged, client notified via email
Takes "before" photos of lobby
→ 3 photos uploaded with timestamps
Starts room checklist
→ Lobby ✓, Offices ✓, Conference rooms...
Completes all rooms, takes "after" photos
→ 8 rooms completed, 12 photos total
Notes: "Stain on carpet in Room 3"
→ Logged as issue, maintenance ticket created
Taps NFC to check out
→ Duration: 1hr 22min, PDF report generated
Report auto-sent
→ Client receives email with photos + checklist