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)7
Medium (40cm)9
Large (45cm)4
XL (50cm)2
Regional Coverage
KPK0%
Ex-FATA0%
Punjab0%
Sindh0%
Balochistan0%
Recent Submissions
All Wheelchair Requests
0 records
| Request ID | Patient Name | Age | Gender | City | Phone | Hip Width | Rec. Size | Condition | Status | Date | 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.
⚙️ 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, email, CC_Team
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.email, d.CC_Team
]);
return ContentService.createTextOutput(JSON.stringify({status:'ok'})).setMimeType(ContentService.MimeType.JSON);
}
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.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
5Public Dashboard mein bhi daalen
atmis-public.html file mein SHEETS_URL variable mein apna URL daalen — public dashboard bhi real data dikhayega