About

Overview Bright Future Brands is building a Crew App, a comprehensive web-based system that streamlines daily operational tasks for our field crew. The app serves as a centralized platform for: Employee availability management Time tracking and timesheets Expense/reimbursement (RTR) submissions Vehicle maintenance logs (New requirement) Video uploads for RTR and maintenance in addition to photos We are looking for a developer to take over and complete the build of this system. Core Functionality 1. Authentication Secure login with email + PIN. Only emails/PINs listed in the database are allowed access. 2. Availability Management Crew submit weekly availability (days only, no time slots). Submissions only allowed on Thursdays (America/Vancouver timezone). Once submitted, availability is locked until the next Thursday. Edits require a reason and are logged for auditing. 3. Timeclock Punch in/out system for work hours. Supports multiple designations: Office, Team Lead, Swamper. Specific workflows: Team Lead → must upload truck photo/comment when clocking out. Office Staff → must log break time when clocking out. Only one open punch per user at a time. All edits audited with required reason. 4. RTR (Reimbursements, Tips, Receipts) Submit financial claims (reimbursements, receipts, tips). Photo or video uploads mandatory for reimbursements/receipts. Photos/videos optional for tips. Files stored in structured Google Drive folders. 5. Maintenance Logging Log truck maintenance and inspections. Photo or video uploads mandatory for all entries. Files stored in structured Google Drive folders. 6. Timezone Handling All time-sensitive operations (availability submissions, timeclock, etc.) must respect the America/Vancouver timezone. Technical Architecture Frontend: React + Vite + Tailwind CSS (responsive web app) Backend: Google Apps Script (JavaScript-based) using Google Sheets as the database Proxy Layer: Cloudflare Worker for handling CORS + request routing Storage: Google Drive for photos/videos Key Business Rules Availability: Thursday-only submissions, locked until next window, edits require reason (audited). Timesheet: One open punch at a time, breaks mandatory for Office, Team Leads must attach truck info at punch-out, edits audited. RTR/Maintenance: Photo/video upload mandatory (except tips), structured Drive storage required. Development Environment Frontend: Node.js, npm, React, Vite, TypeScript, Tailwind CSS Backend: Google Apps Script (with Sheets as DB) Deployment: Static site hosting + Cloudflare Worker for API proxy Deliverables Functional Crew App deployed and connected to Google Sheets + Drive Secure email+PIN authentication Availability, Timeclock, RTR, and Maintenance modules (with business rules above) Full support for video uploads (Google Drive storage, linked in database) Audit logging for edits (availability, timeclock, RTR, maintenance) Documentation for ongoing maintenance and scaling