Maintenance Ticketing System & Inventory Management Portal
A maintenance portal for Cherry Optical Lab: tickets, work orders, parts, teams and purchase orders in one place.

The problem
Mike Shillcox runs maintenance at Cherry Optical Lab. His team tracked requests, work orders and spare parts across separate tools, and parts inventory, the piece that mattered most, was the hardest to keep accurate.
Requesters could not see where their ticket stood, and nobody could tell at a glance which parts were running low or which jobs were waiting on parts.
What we built
A maintenance portal on Softr and Airtable. The home screen opens on the numbers that matter: open work orders, tickets waiting on parts, parts that need ordering, new requests and completed work orders, followed by every low-stock part.
Anyone can raise a work order with photos and a procedure. Each ticket keeps its location, requester, technician, work summary, messages and parts in one place, and purchase orders to vendors are tracked alongside.
- Home KPIs: open work orders, waiting on parts, parts to order, new requests and completed
- Low-stock list with photo, stock on hand, reorder point and shelf location
- Work order form with photos, procedures and ownership
- Ticket details with messages and parts kept on the ticket
- Teams that decide who is notified, with people in several teams
- Purchase orders by vendor, with status and total cost
- Assets, locations and vendors as linked records


How we built it
Softr provides the portal and Airtable holds tickets, parts, assets, locations, vendors and purchase orders, with requesters and technicians reading the same records so status never has to be relayed.
Using a part on a work order updates its stock, and anything at or below its reorder point moves to Parts that need ordering automatically.
Teams group people for notifications, and one person can belong to as many teams as needed, such as a Low Parts team that hears about every reorder.
What changed after launch
Topics
- Field Services & Maintenance
- Airtable
- Softr
- CustomJS
- Email Notifications
- File Uploads
- Client Portals
- client portal
This was a client portal development build. See what a build like this costs, or hire a Softr developer to do the same for you.
Want something like this?
Tell us what you're building. First conversation is on us. Fixed quote in 24 hours, mutual NDA signed on request.
.png&w=1920&q=75)









