🌿 Open Complaints Tracker
Facility & Horticulture Complaint Management
Local only
· ☁️ Setup
Total
—
All records
Overdue
—
Past deadline
Due Today
—
22 Jun 2026
Assigned
0
Allocated
In Progress
0
Being handled
Resolved
0
Completed
On Hold
0
Paused
Cancelled
0
Dropped
High Priority
—
Urgent
By Category
By City
By Criticality
| ⭐ | #↕ | Priority↕ | Type↕ | Category↕ | Client↕ | City↕ | Created↕ | Deadline↕ | TAT↕ | Manager↕ | Mode | Remarks | Status | View / Edit |
|---|
☁️ Cloud Sync — Firestore (Production)
Use Google's free Firestore database so any device — phone, tablet, laptop — stays in sync. Takes about 5 minutes to set up.
1
Create a free Firebase project
Go to console.firebase.google.com → Add project → give it any name → click through the defaults.
2
Add a Firestore Database
In your project: Build → Firestore Database → Create database. Choose Start in production mode → select your location (e.g. asia-south1 for India) → click Enable.
3
Enable Google Sign-In
In Firebase Console: Authentication → Sign-in method → Google → Enable → Save.
Then go to Authentication → Settings → Authorized domains and add your Netlify domain (e.g.
Then go to Authentication → Settings → Authorized domains and add your Netlify domain (e.g.
stellular-rugelach-c7af70.netlify.app).
4
Set Firestore security rules
In Firestore → Rules tab, replace the default rules with:
rules_version = '2';
service cloud.firestore {
match /databases/{database}/documents {
match /{document=**} {
allow read, write: if request.auth != null;
}
}
}
Click Publish. Only signed-in Google users can access the data.
5
Copy your Firebase config
Go to Project Settings (⚙️) → General → Your apps → Add app → Web (</>). Register the app and copy the
firebaseConfig object — it looks like:
{
"apiKey": "AIza...",
"authDomain": "yourproject.firebaseapp.com",
"projectId": "yourproject",
"storageBucket": "yourproject.appspot.com",
"messagingSenderId": "123456",
"appId": "1:123456:web:abc"
}
Note: No databaseURL needed — Firestore doesn't use it.
6
Paste your config below and connect
7
Host this HTML file so it's accessible via a URL
The easiest free option: go to app.netlify.com/drop and drag-and-drop the
complaints_dashboard_firestore.html file. You'll get a live URL (e.g. https://amazing-xyz.netlify.app) in seconds.
8
Share the link with your team
Enter your Netlify URL below to generate a QR code:
Complaint Details
Complaints Dashboard · open_complaints_22June2026.xlsx · All changes saved in browser