Keeping track of every custom order from appointment to pickup

The practice manages custom products that may take days or weeks to arrive or be made. One client might have several items connected to the same appointment, and each item could be at a different stage. Staff needed to know what was ready, what was delayed, where it belonged, and who needed to be told.

Assumptions such as “one client, one item” quickly failed. The tool had to handle any number of products while still giving staff a simple answer to the practical question: what can this client pick up today?

I built connected order and production trackers in Google Sheets. New entries receive the right checkboxes, menus, dates, and status choices automatically. When an item changes stage, the tool records when it happened. Completed records can be archived and restored without losing their history.

Rather than asking staff to search several lists, the system brings together each day’s appointments and every item connected to them. It clearly marks items as ready, not ready, or missing and includes the notes needed for the visit.

The system produces pickup sheets for each clinic and clinician, prepares notifications, flags orders that have been stuck too long, and keeps a record of important changes.

Staff still work in familiar Google Sheets, but the system behaves more like a custom application. New fields and choices can be added without breaking everything built around them.

Each item now has a clear status, each status leads to an action, and each appointment shows the staff the complete picture.