Enterprise Change Control & Task Tracker

Project Title: Regulated Change Management & Operations Tracker Tools Used: Airtable (Bases, Linked Records, Rollups, Interfaces), CSV Automation The Challenge: A pharmaceutical manufacturing operation required a simple, reliable change management system to track parent change records and related child activities without overwhelming non-technical operators The Solution: Architected a 4-table relational Airtable database featuring custom formula fields, rollups, automated reminders, and role-based Airtable Interfaces Key System Features & Results: 4 Interconnected Core Tables: Structured separate linked tables for Pre-Assessment/Intake, Parent Change Records, Child Action Items, and Meeting Actions/Decisions Dynamic Field Logic: Configured formula fields ("days left", "overdue flag") and rollup fields ("open child count", "overdue child count") for instant visibility into project status User-Friendly Airtable Interfaces: Built custom interface dashboards including "My Tasks", "Pending / Overdue Actions", "Change Record Overview", "Meeting Discussion View", and "Leadership Summary View" Automated Notifications & Exporting: Established automated reminders for due-soon items, overdue tasks, and blocked item notifications, along with CSV templates for periodic system exports