Equipment Rental
Check-in, Check-out, Condition Tracking
THE PROMPT
“I run an equipment rental company with 200+ items — generators, scaffolding, power tools. I need QR-coded inventory, condition check-in/check-out with photos, automated billing, and availability tracking.”
Lattice builds the complete system from this single prompt: 5 entities, 59+ fields, 6 automations.
Data Schema
(5 entities, 59 fields)| Field | Type | Required |
|---|---|---|
| Rental ID | Auto-ID (RNT-####) | |
| Customer | Relation → Customers | |
| Equipment | Relation → Equipment | |
| Status | Select[Reserved, Active, Returned, Overdue, Invoiced] | |
| Checkout Date | DateTime | |
| Expected Return | DateTime | |
| Actual Return | DateTime | — |
| Rate Type | Select[Daily, Weekly, Monthly] | |
| Rental Amount | Currency (formula) | — |
| Damage Charges | Currency | — |
| Total | Currency (formula) | — |
| Checkout Condition | Relation → Condition Reports | — |
| Return Condition | Relation → Condition Reports | — |
| Notes | Long Text | — |
Automations
(6 rules)When QR code scanned at checkout
When Rental status → "Returned"
When Expected Return date passed
When Condition Report shows damage
When Equipment returned to "Available"
When Equipment service due
Available Views
Sample Workflow: Generator Rental & Return
Customer arrives, requests 20kW generator
→ Staff scans QR on generator #EQ-0147
Checkout condition report started
→ Photos captured: body good, fuel full, accessories complete
Customer signs rental agreement on tablet
→ Rental created, daily rate $150, expected return Friday
Customer returns generator, staff scans QR
→ Return condition report started, compared to checkout photos
Minor scratch noted on housing, fuel at 1/2
→ No damage charge (normal wear), fuel charge added
Return complete
→ Invoice generated: 5 days × $150 + $40 fuel = $790, emailed to customer