Project: Multi-Location Inventory Tracking System for a National Courier Company (Airtable)

Manual/messy process: A logistics company with independent contractor drivers across 13 US cities had no centralized way to track inventory levels. Getting a stock count meant manually contacting each city's contact person, with no structured follow-up if someone didn't respond, no historical record of what was reported when, and no single view of company-wide inventory status.

What I automated: Built a full Airtable system with four interconnected tables (Cities, Inventory Items, Current Inventory, Inventory Check Log) and four automations: biweekly inventory requests sent by email and SMS to all 13 city contacts simultaneously, 24-hour follow-up reminders that automatically escalate to a backup contact if the primary doesn't respond, form-submission processing that updates live inventory and logs the response, and confirmation emails sent back to whoever submitted the count. Paired it with 13 mobile-friendly forms, one per city, pre-filled via URL parameters, and dashboard views with conditional formatting so status (Reported / Pending / Overdue) is visible at a glance.

Measurable outcome: replaced a fully manual, ad hoc check-in process with a system covering all 13 cities on a fixed twice-weekly cadence, cut the time to get a full inventory picture from days of chasing contacts to under 24 hours.