Skip to main content
Portalcrafter Logo
CLIENT PORTALS

Maintenance Ticketing System & Inventory Management Portal

A maintenance portal for Cherry Optical Lab: tickets, work orders, parts, teams and purchase orders in one place.

Maintenance Ticketing System & Inventory Management Portal project hero
Industry
Timeline
~5 weeks
Stack
Airtable · Softr · CustomJS · Make · Google Sheets
01 · Problem

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.

02 · Solution

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.

Maintenance Ticketing System & Inventory Management Portal detail image 1
Maintenance Ticketing System & Inventory Management Portal detail image 2
03 · Process

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.

04 · Results

What changed after launch

5 KPIs
Open, waiting on parts, to order, new and completed work on the home screen
Low stock
Parts at or below their reorder point flagged automatically
One hub
Tickets, parts, teams and purchase orders in a single portal

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.

Let's build it

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.

See Pricing & Packages
Reply within 24 hoursMutual NDA signed within 24 hoursHonest fit recommendation
More Work

Other projects you might like