Calendar-Wise Job Dashboard Google Sheets
Select a date to view jobbers and day-wise orders. Stats and lists show only that date's data.
Job Calendar
Dates with jobs show jobber names. Click a date to open day-wise order details below.
Day-Wise Orders Select a date
Choose a date from the calendar to see that day's jobbers and orders.
Records by Print Type
Garment Raw Entry
Garment is a separate entry. Use Add Garment Entry for product and size-wise quantity.
Day-Wise Orders
| Jobber Name | Party Name | Print Type | Logo Location | Product | Style | Colour | Collar Style | Tipping Style | Quantity | Actions |
|---|
All Print Details 0 Records
Comprehensive table view of all saved Jobber print records.
| Created At | Jobber Name | Party Name | Print Type | Logo Location | Product | Style | Colour | Collar Style | Tipping Style | Quantity | Logo Image | Actions |
|---|
Jobber Wise Back Sheet
Select any Jobber to inspect their dedicated print register hierarchy (Jobber → Party → Print Type → Logo Location).
Select Jobber
Party Wise Ledger Back Sheet
Select any Party to view their order ledger hierarchy (Party → Jobber → Print Type → Logo Location).
Select Party
Print All Data
Select records first. Print becomes available after a selection: Jobber-wise, Party-wise, Garment, or Printing.
Jobber-wise Entry Print
Select records under a jobber, then use Jobber-wise Print.
Party-wise Entry Print
Select records under a party, then use Party-wise Print.
Printing Records
Add New Print Entry records only. Select rows, then use Printing Print.
| Created At | Jobber Name | Party Name | Print Type | Logo Location | Quantity |
|---|
Garment Records
Add Garment Entry records only. Select rows, then use Garment Print.
Backup & Data
Export or restore print and garment records. Restore updates every page in the app.
Data Backup Operations
Export Backup
Download the latest jobber print records from Google Sheets as a JSON backup file.
Restore All Records
Restore a JSON backup to every page. Use Add Google Sheet Entries to append current printing and garment rows into the connected Google Sheet.
Remove All Records
Completely wipe all records from Google Sheets to start with a fresh empty register.
Shared Google Sheets Database
Records are saved in Google Sheets through a Google Apps Script Web App. Configure the connection on the
page (password protected). Full written steps are also in SETUP.md.
Google Sheets Setup Not Connected
Connect this app to your Google Sheet so all PCs share the same records.
Web App Connection
Paste the deployed Apps Script URL ending with /execUsed by the header SHEET button. Auto-filled after a successful connection if Apps Script is updated.
The URL is saved in this browser. You can also put the same URL in js/config.js when copying the folder to another PC.
Step-by-step Setup
-
Create a Google Spreadsheet
Open Google Sheets and create a blank spreadsheet. Name it something like Jobber Wise Print Details.
-
Create the
RecordssheetRename
Sheet1to exactlyRecords. -
Add header columns in row 1
Use these headers left to right:
Created At · ID · Jobber · Party · Print Type · Logo Location · Quantity · Logo Image · Updated At · Product · Sizes · Style · Colour · Collar Style · Tipping Style -
Open Apps Script
In the spreadsheet go to Extensions → Apps Script and delete any default sample code.
-
Paste the API code
Copy everything from this project file
google-apps-script/Code.gs, paste it into Apps Script, then Save. -
Deploy as Web App
Click Deploy → New deployment → Web app.
- Execute as: Me
- Who has access: Anyone
Authorize when Google asks, then Deploy.
-
Copy the Web App URL
Copy the URL ending with
/exec(not/dev) and paste it in the box above, then click Save URL and Test Connection. -
Test the app
Add a record, confirm it appears in the Google Sheet, refresh the page, then try Edit, Jobber CSV download, and JSON Backup.