My Expert Editing Hub Dashboard
Jobs, payments and status updates in one clean workspace.
Current Date & TimeLoading…
Private Payment Summary
Payment figures stay hidden until you press the eye button.
Total Amount₹ ••••••
Total Due Amount₹ ••••••
Search Jobs, Proprietor & Studio — Complete Job Update
Search a proprietor or studio to view every linked job together. Use Edit All for Remark, Note and complete details.
Showing latest active jobs.
Add Advance: New payment is added automatically; Due and Payment Status update instantly.
| Booking ID | Type | Client / Studio | Size / Remark | Status | Delivery | Store Status | Payment | Action |
|---|
Proprietor / Studio Registration
Register the proprietor, studio and mobile number together.
How it works: After saving, open Add New Job and choose the registered proprietor/studio. The proprietor name, studio name and mobile number will fill automatically.
| Proprietor | Studio Name | Mobile / WhatsApp | Total Jobs | Total Amount | Total Due | Action |
|---|
This ComputerAuto Save ON0 Jobs · 0 registered Clients
Google Sheet SyncNot configuredOpen Connection Settings once
Last Sheet RefreshNeverWaiting for connection
Automatic Two-Way Sync
No daily setup is needed. Dashboard and Google Sheet keep each other updated safely.
Setup required
Local Auto SaveEvery Job, Client, Remark, Note and payment update is saved in this computer automatically.
Always ONGoogle Sheet Direct EntryAdd or edit a row in the Jobs or Clients tab. The Dashboard checks the Sheet every 60 seconds.
Setup neededSafe MergeNew and changed Sheet rows are merged into this computer. Missing Sheet rows never auto-delete local records.
ProtectedFor direct entry: open Google Sheet → Jobs tab → add a row. Internal IDs may stay blank.
Connection Settings — open only when you need to change them
First-time Google Sheet setup — technical help
- Create a blank Google Sheet and copy its ID from the Sheet URL.
- Open Extensions → Apps Script and replace the old code with the supplied code below.
- Add SPREADSHEET_ID and BACKUP_SECRET in Project Settings → Script Properties.
- Deploy a new Web App version, execute as Me, and allow access to Anyone.
- Paste the /exec URL and the same secret in Connection Settings, then save once.
Direct entry: Use the Jobs and Clients tabs. Leave Internal Job ID, Client ID, Due and Payment Status alone; they are automatic. Blank Booking ID becomes the next MEH number.
Emergency Tools
Use these only for an extra copy or recovery.
Excel Copy
Jobs and Clients in a readable Excel workbook.
Complete Data Backup
Download a full emergency recovery file.
Complete App Backup
Download the full app with the latest data for this computer.
Emergency Google Restore
Manually load the cloud copy. Confirmation is required.
Restore Data File
Manually replace local records from a JSON backup.