Total Requests
0
↑ 5 today
Delivered
0
↑ 3 this week
Pending
0
● Action needed
Pressure Risk
0
● High priority
This Month
0
↑ vs last month
Monthly Trend
Size Distribution
Small (35cm)0
Medium (40cm)0
Large (45cm)0
XL (50cm)0
Regional Coverage
KPK0%
Ex-FATA0%
Punjab0%
Sindh0%
Balochistan0%
Recent Submissions
All Requests
0 records
| Request ID | Patient Name | Age | Gender | Phone | Device Type | Rec. Size | Address | Status | Date | Proof | Actions |
|---|
Showing 0 of 0
68%Delivery Rate
4.2dAvg Processing
82%Satisfaction
91%Form Complete Rate
12%Pressure Risk
Requests by Age Group
Gender Breakdown
Weekly Trend — Last 8 Weeks
Pushing Method Distribution
Export Data
📊
Excel (.xlsx)
Full data with all fields, auto-formatted columns, ready for analysis
📄
PDF Report
Formatted report with summary stats, table, and ATMIS branding
📝
CSV (Raw)
Comma-separated values, compatible with any software
ℹ️ Export includes 0 records. Apply filters on the Requests tab first, then export filtered data.
🏢 Vendor / Company Management — Full Profile + Performance
➕ Add New Vendor (Complete Details)
📋 Registered Vendors (Performance & Ratings)
💡 Vendor Portal URL: atmis.pk/atmis/atmis-vendor.html
Vendors use same username/password to login, see requests and place bids.
Vendors use same username/password to login, see requests and place bids.
⚙️ Google Sheets Live Connection
1Google Sheets — New Spreadsheet
Pehli row mein yeh headers daalen (exactly aise hi):
timestamp, Request_ID, Naam, ID_Number, Umr, Gender, Phone, Address, Goals, A_Hip_Width_mm, B_Seat_Depth_mm, C_Calf_Length_mm, D_Back_Height_Rib_mm, E_Shoulder_Blade_mm, Recommended_Size, Device_Type, email, CC_Team, Status
2Google Apps Script
Extensions → Apps Script → naya script → paste karein → Save:
function doPost(e){var sheet=SpreadsheetApp.getActiveSheet();var d=JSON.parse(e.postData.contents);sheet.appendRow([new Date(),d.Request_ID,d.Naam,d.ID_Number,d.Umr,d.Gender,d.Phone,d.Address,d.Goals,d.A_Hip_Width_mm,d.B_Seat_Depth_mm,d.C_Calf_Length_mm,d.D_Back_Height_Rib_mm,d.E_Shoulder_Blade_mm,d.Recommended_Size,d.Device_Type,d.email,d.CC_Team]);return ContentService.createTextOutput(JSON.stringify({status:'ok'})).setMimeType(ContentService.MimeType.JSON);}
3Deploy as Web App
Deploy → New Deployment → Web app → Execute as: Me → Who has access: Anyone → Deploy → URL copy karein
4Dashboard mein URL daalen (save ho jayega)
5Public Dashboard mein bhi daalen
atmis-public.html file mein SHEETS_URL variable mein apna URL daalen — public dashboard bhi real data dikhayega