Admin session active
⚠ No projects have been added to this program yet — ask your administrator to add projects under the Setup tab.
Admin: add team members (with emails), locations and schemes in Setup tab first.
Duplicate rule: record is duplicate only when Name + Mobile + Age + Location all match. Multiple family members may share the same mobile.
①
Find a Beneficiary🎤 Search by Name (speak or type)
OR
📱 Search by Mobile Number
Multiple family members may share the same mobile number — use this for quick service updates.
②
Family members on this number✎
Update servicesService history
Add new service — greyed = already completed
tap & speak scheme names
+
New beneficiary entryDemographic Details
Schemes / Services — select one or more
Required — Ayushman Card scheme select hone par, Sashakt Abhiyan – II project mein.
Filters 0
Search
Location
Member
Gender
Scheme
Project
Program Filter
Project Filter
Min Age
Max Age
Date Range
to
0 records
| Name | Age | Mobile | Location | Member | Date | Project | Svcs |
|---|
No records match filters
Filters
Location
Service / Scheme
From
To
Total Beneficiaries
0
Women
0
Locations
0
Total Services
0
👥
Member performance🧑🤝🧑
Member Performance — Detailed (date / location / service wise)⚧️
Gender-wise🧬
Caste / Category-wise🛐
Religion-wise♿
Differently-abled-wise📊
Scheme-wise🗂
Project-wise Beneficiaries🔍
Program / Project Deep Analysis
Project:
Scheme-wise
Location-wise
Gender breakdown
📅
Last 7 days📍
Location-wise🔢
Location-wise — Scheme Engagement
Threshold:
schemes — har location mein kitne log 5+ se jude vs <5.
⌛
Age groups📥
Excel Bulk Upload
Step 1: Download the Excel Template below
Step 2: Fill in your data (follow the format exactly)
Step 3: Upload the filled Excel file — the system will validate and save automatically
Step 2: Fill in your data (follow the format exactly)
Step 3: Upload the filled Excel file — the system will validate and save automatically
Excel File Upload Karo
📂
Click to browse or drop file here
.xlsx ya .csv file (max 5000 rows)
✅
Preview — Verify before uploading✅
Upload Complete| # | Name | Mobile | Location | Program | Project |
|---|
📅
Fix Old DatesPurane records ki enrollment date theek karo. Date createdAt column me jaati hai (alag "enrollmentDate" column database me nahi banta). Sirf date badlegi — koi record delete/add nahi hoga.
⚡ Auto-fix from remarks: jin records ke remarks me "Camp date: ..." likha hai (jaise Sahyog camps), unki sahi date ek click me set ho jayegi — remarks se date nikaal ke. Manual kuch nahi karna.
Date nikalne ke baad remarks ka "Camp Date: ..." prefix bekaar hai. Hatana ho to (note / Vendor / Team safe rahega):
Ya — manually criteria se set karo
⚙ Advanced: sirf current date-range wale records (optional)
Ya — poori sheet export karke per-row dates theek karo:
1) saara data download karo → 2) Excel me enrollmentDate column theek karo (id column mat badlo) → 3) wahi sheet wapas upload karo. System ID se match karke sirf date update karega — kuch delete/duplicate nahi hoga.
1) saara data download karo → 2) Excel me enrollmentDate column theek karo (id column mat badlo) → 3) wahi sheet wapas upload karo. System ID se match karke sirf date update karega — kuch delete/duplicate nahi hoga.
👥
Users & Access Control
3 roles:
🔴 Admin — Full access to all data and settings
🟢 Team Member — Data entry & view for own entries in assigned project only
🟨 Donor — Read-only status + Excel for assigned project only (mobile numbers hidden)
🔒 Team & Donor login needs an email + password. Set a password for each user below.
🔴 Admin — Full access to all data and settings
🟢 Team Member — Data entry & view for own entries in assigned project only
🟨 Donor — Read-only status + Excel for assigned project only (mobile numbers hidden)
🔒 Team & Donor login needs an email + password. Set a password for each user below.
No users yet
🗂
Programs & Projects Management
Structure: Program → Project → Schemes
4 programs are fixed. You can add projects under each program. Each project can have its own set of schemes.
4 programs are fixed. You can add projects under each program. Each project can have its own set of schemes.
🛠
Project: 📋 Schemes / Services
These schemes appear in the entry form when a field worker selects this project.
📍 Locations for this project
Only these locations show in the entry form for this project — less scrolling for field staff.
📝 Extra / Custom Fields — jo info ye donor maange
Kuch projects mein donor extra details maangta hai (jaise Card Number, Enrollment Number, Bijli Bill Number). Yahan add karein — ye fields sirf is project ki entry form mein dikhenge.
These fields appear in the entry form (and in records / Excel export) for this project.
🔗
API ConnectionTo change the Google Sheet connection, paste the new Apps Script URL below:
🔑
Admin Password ChangeUpdate the Admin password used on the login screen:
Default password:
admin123🗑
Delete Beneficiary RecordsYahan se aap beneficiary records ko permanently delete kar sakte hain. Yeh seedhe Google Sheet se hat jaate hain aur wapas nahi aate. Yeh action undo nahi ho sakta.
📁 Project-wise delete
📅 Date-wise delete (entry date)
Tip: ek hi din ke liye From aur To dono same rakhein.
⚠️ Delete ALL beneficiary records
Saare records hat jaayenge. Config (users/locations/schemes/projects) safe rahega.
⚠️
Danger Zone — Reset All DataPressing this button will permanently remove all Users, Locations, Schemes, and Projects from the Google Sheet.
Beneficiary records will not be deleted — only configuration data will be reset.
Beneficiary records will not be deleted — only configuration data will be reset.