Enter password to access the Shop Board
Incorrect password. Try again.| # | PO # | Customer | Year / Make / Model | Work Description | Status | Arrival | Notes | Actions |
|---|
| # | PO # | Year / Make / Model | Work Done | Customer | Arrival | Notes | Status | Actions |
|---|
Paste your CSV data below. Expected columns:
PO, Vehicle, Customer, Work, Status, Arrival, Notes
First row must be the header row. Status values: empty, in-progress, waiting-part, waiting-tech, delayed, done.
To enable auto-backup to Google Sheets, follow these steps:
1. Go to sheets.google.com and create a new spreadsheet named Lee Transmission Shop Board.
2. Click Extensions > Apps Script.
3. Delete the existing code and paste the script shown below.
4. Click Deploy > New deployment, select type Web app, set "Who has access" to Anyone, click Deploy.
5. Copy the Web App URL and paste it below.