Problem & Context
Residents often needed to visit the kelurahan office in person just to ask about administrative service requirements such as KTP, KIA, SKTM, and other services. The project aimed to make this information easier to access online and provide a practical complaint channel.
Goal
Create a lightweight public-service portal that centralizes service information and provides a simple way for residents to submit complaints.
Approach
Built a lightweight web portal using React with Google Sheets as a cloud-based CMS, chosen for being simple, familiar, and practical for the project's operational context.
Technical Implementation
Built the frontend with React and Vite in JavaScript. Google Sheets was used as a lightweight cloud CMS instead of building a dedicated administrative backend — service information and requirements were stored there and retrieved by the web app for the public portal. A complaint workflow generates a pre-filled WhatsApp message to the kelurahan.
Outcome
Created a centralized online information portal that makes public-service requirements easier to access and provides a structured complaint pathway through WhatsApp.
Lessons Learned
Choosing Google Sheets as a cloud CMS matched the project's stated need for a simple, familiar operational fit and avoided a separate administrative backend. Pairing an online service-information portal with pre-filled WhatsApp complaints kept the two stated functions in a lightweight web application.