Complete training management system. Auto-generates personalized timelines, tracks position progress via Google Form, live dashboard with certification readiness, email alerts, and weekly schedule auto-population.
Google Apps ScriptGoogle FormsSheets Integration
This is a Google Apps Script application. It runs inside Google Sheets and cannot be opened directly in a browser. Follow the setup steps below to deploy it to your Google account.
Features
Auto-generated personalized training timelines per employee
Google Form integration for progress tracking
Live dashboard with certification readiness status
Email alerts for overdue training and milestones
Weekly schedule auto-population
Deduplication sidebar for cleaning form responses
Alert settings configuration dialog
Data sync across multiple sheet tabs
Setup Steps
Create a new Google Sheet for Training Tracker.
Open Extensions → Apps Script and paste each .gs file in order (01 through 08).
Create HTML files: TimelineDialog.html, DeduplicationSidebar.html, AlertSettingsDialog.html.
Run the initial setup function from the custom menu.
Create a Google Form linked to the sheet for training submissions.
Configure alert settings via the Training menu → Alert Settings.