One tracker for every complex equipment shipment request
A precision electronic components manufacturer manages all logistics projects and complex equipment moves in Airtable. Shipment requests arrive through a standardized intake form, trigger automated status confirmations, and route notifications to the correct facility contacts automatically, replacing a manual email process with no visibility or audit trail.
The problem
Complex equipment moves involve hazardous materials classifications, carrier selection, dimensional data, and multiple facility contacts, yet all of that was tracked in email threads with no structured record. Requesters had no visibility once a ticket was submitted, and logistics coordinators spent time re-entering data from email into separate tracking documents.
Routing notifications to the correct facility contact required knowing which location a shipment involved and finding the right email address manually. With no audit trail, determining the status of any shipment meant searching inboxes rather than checking a shared system.
What they built
The logistics team deployed Airtable as a consolidated tracker for all shipment projects. A form captures each request at intake, creating a record that holds dimensions, hazardous materials details, carrier information, tracking numbers, and pickup and delivery dates. A linked Locations table surfaces the correct facility contact for each record via lookup fields.
Automations send a confirmation email when a ticket is submitted and follow-up notifications when carrier and tracking details are assigned. The logistics team manages all active shipments from a work queue view, and synced or manually updated records between bases reduce re-entry when data crosses systems.
The outcome
Requesters receive an automatic confirmation when their ticket is submitted and updates when key fields are populated, without any manual follow-up by the logistics team. Plant managers can track shipment status without contacting the logistics coordinator.
Location-based routing ensures notifications reach the right facility contact every time, and all shipment records carry a full history. The manual email re-entry process that previously consumed coordinator time has been eliminated.
Inside the solution
Logistics Project and Shipment Request Tracking
Supply Chain & Inventory Management
- Form-based shipment request intake creating records in the logistics work queue
- Detailed shipment tracking with dimensions, hazardous materials, carrier, and tracking numbers
- Automated ticket confirmation and status update emails when required fields are set
- Location-based email routing via linked Locations table and lookup fields
- Sync or manual updates between logistics bases to reduce re-entry
- Manual re-entry of shipment data between email and tracking documents
- Email-based request tracking with no visibility or audit trail
- Difficulty routing notifications to the correct facility contact
- No consolidated view of shipment status for requesters and plant managers
- Lack of standardized intake for complex equipment moves
- Consolidated logistics tracker replacing manual email tracking
- Reduced coordinator effort through automated status notifications
- Better visibility for plant operations and requesters
- Scalable intake with location-aware automated routing
- Improved data quality and full audit trail for every shipment
- Logistics
- Operations
- Plant Management
- Forms
- Automations
- Interfaces
- Outlook email
- Linked tables
Logistics project and shipment request tracking
Track every complex equipment shipment request in one place: a standardized intake record captures dimensions, hazardous materials classifications, carrier, tracking number, and pickup and delivery dates, while a linked Locations table surfaces the right facility contact for each move. Automations confirm the ticket on submission, route a status update to that facility contact the moment carrier and tracking are assigned, and send a weekly work queue digest, with AI columns that triage new intake, brief plant managers, and draft the status update email.
From email threads to a structured shipment request system
Build the intake form
Link locations and route notifications
Automate status confirmations
FAQ
Frequently asked questions
Each shipment record links to a row in a separate Locations table that holds the facility name, address, and contact email. Lookup fields on the shipment record pull the correct contact email through automatically. Automations reference that lookup field when sending notifications, so the right facility contact receives every update without manual address lookup.
The form collects the information logistics coordinators need to manage a complex equipment move: package dimensions, hazardous materials classifications, preferred carrier, requested pickup date, requested delivery date, and the originating facility. All of that data lands in the shipment record at intake, with no re-entry required.
Two automation triggers are in place. The first sends a confirmation email to the requester as soon as the form is submitted. The second sends a status update when the carrier and tracking number fields on the shipment record are assigned by the logistics team, confirming the shipment is booked.
A filtered view shows all shipment records that are active or awaiting action, sorted by the fields the team uses to prioritize. Coordinators update carrier, tracking, and pickup or delivery details directly in the record, which triggers the relevant automations and keeps the audit trail complete.
Yes. The Locations table can hold as many facilities as the operation requires. Each new location gets its own row with contact details, and linked records connect shipments to the correct facility automatically. Adding a new site means adding a row to the Locations table, not redesigning the system.