Jean-Claude Biguine

All Tickets

#	Date	Center	Subject Type	Subject	Raised By	Prio	⏳ Waiting	📅 Expected	TO	Status	Action

📍 Basic Information

Center / Salon *

Date Raised *

Raised By *

Priority *

⏳ Waiting Since *

Date this issue has been pending

📅 Expected Resolution Date

🏷️ Subject Classification

Subject Type *

Subject *

📧 Email Routing

TO

CC

TO: NSH & AM · CC: CEO, AM & IT Resolver · BCC: Admin (all configured in Admin → Email Config)

📝 Description & Attachments

Issue Description *

Screenshots / Attachments

📎

Drag & drop files here or click to browse

Images, PDF, Word, Excel — max 5MB each

Open / Pending

👈

Select a ticket from the left to update it.

⚙️ Apps Script URL (paste your new URL here)

⚠️ Your current URL has /a/macros/biguineindia.com/ — this is domain-locked and will NOT work from external pages.
You must create a NEW deployment in Apps Script → the new URL will have /macros/s/ (without the domain part). See instructions below.

📋 How to get the correct URL — click to expand

1. Open Google Sheet → Extensions → Apps Script
2. Click Deploy → New Deployment (not "Manage Deployments")
3. Click ⚙️ gear icon → select Web App
4. Description: HelpDesk v3
5. Execute as: Me
6. Who has access: Anyone ← (NOT "Anyone in biguineindia.com")
7. Click Deploy → copy the URL shown
8. The URL should look like: https://script.google.com/macros/s/ABC.../exec
(no /a/ or domain name in it)
9. Paste that URL above → Save URL → Test Connection

📤 Push All Data to Google Sheet

First time setup — push your Salons, Users, Tickets and Tokens to Sheet in one click

🔗 Login Links (Magic Links)

🔗 Each user gets a permanent link they can bookmark or save in WhatsApp. Share the link — they click it and are automatically logged in. Links never expire unless you regenerate them.
Base URL:

User	Role	Username	Token	Login Link	Actions

👤 User Accounts

⚠️ Passwords are visible here for admin reference. Usernames are lowercase, no spaces (e.g. varun, sandeep). Roles: admin · nsh · am · it · salon

Username	Full Name	Email	Role	Zone / Region	Current Password

🏢 Master Salon Data

Salon Name	Display Name	Brand	Sub-Company	City	Zone	NSH	AM	Salon Email	AM Email	NSH Email	HR

🎨 Ticket Form Builder

Admin-only · changes apply instantly to Raise Ticket form

Form Sections: Basic Info Salon Auto-fill Subject Classification Issue Description Attachments / Screenshots Email Routing Box

Subject Types

← Select a Subject Type

Select a subject type from the left panel to edit its subjects and fields.

📧 Global Email Config

No hardcoded emails — configure everything here. Changes apply immediately to all tickets.

🟢 CEO Email (CC on every ticket · can approve)

🔧 IT Resolver Email (CC · can resolve/close tickets)

🔕 BCC Email (silent copy on every ticket)

Additional CC (comma-separated, added to every ticket)

ℹ️ Routing Logic

TO: NSH & AM of the selected salon (from Master Data).
CC: CEO Email + AM + IT Resolver (set above).
BCC: BCC Email (set above).
Approve: NSH role or CEO Email user only.
Resolve: IT Resolver Email user only.