Website Administrasi Data Terpadu
A centralized admin dashboard for Desa Cahaya Baru — letting village administrators view, create, edit, and delete population datasets (residents per RT, livelihood, education, service letters, complaints) that publish live to the public village website.
Built for KKN-UGM at Desa Cahaya Baru, South Kalimantan. Village records were still paper-based and scattered across departments, with no single source of truth — population, education, and service data had to be reassembled manually each time the kecamatan requested a report. I built one admin dashboard that centralizes every dataset and syncs to the public village website in real time, so updates from the admin surface instantly where villagers actually see them. Data persists in Google Sheets via Google Apps Script — zero backend cost, no infrastructure for village staff to maintain. (The public-facing site is documented as a separate portfolio piece.)
- Built the full admin dashboard in React + Vite + Tailwind — multi-section dropdown navigation spanning Kependudukan, Perkembangan, and Pelayanan Online modules
- Inline table editor with pencil/check/cross UX — click a cell to edit, commit or cancel inline; changes persist to Google Sheets instantly
- Full CRUD operations (create / read / update / delete) on every dataset, plus global search filtering across all tables
- Leveraged Google Apps Script as a serverless API layer bridging the dashboard and Google Sheets — zero-cost backend for village administration
- Real-time public-site sync — every admin write automatically propagates to the public-facing village website
React.js
Vite.js
Tailwind CSS
Google Cloud
Google Apps ScriptHero landing — the admin dashboard for Desa Cahaya Baru, centralized control surface for all village datasets.
Login — authenticated access to the admin dashboard.
Kependudukan → Mata Pencaharian — chart visualization of livelihood data; this section (Usia, Penduduk, Mata Pencaharian, Siswa) syncs live to the public village website.
Perkembangan → Putus Sekolah — school dropout tracking, part of the village growth dataset alongside Jumlah Penduduk and Tingkat Pendidikan.
Pelayanan Online section menu — Surat Masuk (incoming letters) and Aduan Masyarakat (citizen complaints) modules.
Surat Masuk workflow — processing incoming official correspondence.
