👥 User Management

➕ Create New User

🌐 Online User Storage (Apps Script)

Users are stored as a table (one row per user) in the DashboardUsers sheet via Apps Script, so they persist across all browsers/devices and are readable directly in Sheets. This MUST be the same Apps Script project that serves Sales/HRMASTER/Employees — one unified doGet/doPost, no duplicates. See the full Code.gs file provided separately; paste it whole into Extensions → Apps Script, replacing everything there.

// ── This is a SUMMARY only — paste the full Code.gs file (provided ── // ── alongside this dashboard) into ONE Apps Script project. ── // Deploy as: Web App · Execute as: Me · Who has access: Anyone // Then paste the same /exec URL here AND in the top "Apps Script URL" box. // doGet handles: ?action=list (users) · ?action=sales&url=... (proxy) // ?action=hrmaster · ?action=employees // doPost handles: {action:'save', users:[...]} → writes DashboardUsers // sheet as ONE ROW PER USER (Username, Password, FullName, // Role, Brand, Centers, Download, SalesURL, // MustChangePassword, LastPasswordChange)

The URL is saved in your browser. Once set, all user changes sync to the Sheet automatically.

👤 All Users

Username Full Name Role Brand Centers Download Sales URL Pages Password Actions
No users yet. Create one above.

📐 Attendance Rules

🌐 Global Rules — apply to every employee unless overridden below

Weekend days and holidays are excluded from "Absent" counts and from late check-in checks. Manage specific dates in the Holidays screen.

➕ Add Employee Exception

Override the global thresholds for specific employees — e.g. an employee who only needs to complete 7h40m to count as a Full Day.

📋 Active Exceptions

Employee Code Name Full Day Less Than Late Check-in Note Actions
No exceptions yet. Use the form above.
Employee Attendance & Performance
?
—
👤 Loading employees…
→
Fetching… 0%
✅
—
Present (Full Day)
❌
—
No Attendance
🚪
—
No Checkout
⏱
—
Less Working Hrs
👤
—
Unique Employees
📋
—
Total Records

Attendance Records

0 records
Brand ↕ Center Code ↕ Center Name ↕ Emp Code ↕ Employee Name ↕ Job Title ↕ Month ↕ Date ↕ Day ↕ Check In ↕ Check Out ↕ Working Hrs ↕ Status ↕
📅

No data yet

Select a date range and click Fetch Attendance
📅
Fetch attendance data first, then switch to this view.
Legend:
Full Day
No Checkout
Less than 8:45
Less Working Hrs
No Attendance
Weekend (Sat/Sun)
Holiday
No Data
➕ Add Holiday / Off Day
💡 Weekend (Sat/Sun) are automatically marked in blue.
Holidays you add here show in purple in the heatmap.
Absent on weekends/holidays won't count in summary.
🗓 Holiday List
Date Day Holiday Name Type Brand
No holidays added yet.
Google Sheet → File → Share → Publish to web → select the Sales sheet → CSV → Publish → copy the link
All Brands▼
All Salons▼
All Designations▼
All Categories▼
All Employees▼
All Years▼
All Months▼
📊

Configure the Sales sheet URL above and click Load

All Brands▼
All Salons▼
All Departments▼
All Cities▼
👥

Loading headcount data…