Project Overview I operate a school bus transportation company and need a simple automated digital system that allows employees to submit daily and weekly bus inspection information via mobile phone. The system must automatically track, timestamp, notify management, and maintain a dashboard for oversight. The goal is operational accountability, compliance tracking, and preventive maintenance management. Core Features Required • Daily Bus Startup & Inspection Form with required fields (driver name, bus number, timestamp, odometer, fuel, DEF, battery, fluid check, leaks, tires, lights, stop arm, camera, GPS, safety equipment, credentials, cleanliness, yard location, notes, and photo uploads). • System must flag any failed or issue-marked items automatically. • Bus Breakdown Report Form including bus number, date/time, location, issue description, diagnosis, towing status, technician, repair details, test drive confirmation, final status, and repair photos. • Automatic timestamping of all submissions. • Automatic email notifications to management for flagged issues and breakdown reports. • Dashboard showing all buses, service status, open repair tickets, and last inspection date. • Weekly summary report automatically emailed to management. • Search and filter functionality by bus number or date. • Secure login access (if possible). • Mobile-friendly design. System Requirements • Must be simple and user-friendly. • Must function on mobile devices. • Preferred platforms: Google Workspace or Airtable unless a better solution is proposed. • Data must be stored in a master sheet/database. • Fields must be editable and expandable. • Clean and organized dashboard interface. Deliverables • Fully working automated system. • Admin access credentials. • Clear instructions for use. • One revision included. • Loom video walkthrough explaining setup and usage. • Basic automation documentation.