Digitalization of administration is now an important need for villages, sub-districts, schools and small agencies. Managing data manually using separate books or files often causes problems such as lost data, duplication, difficult to find, and takes a long time when making reports. This system can be accessed from anywhere without the need for an expensive server or complicated installation.
This article discusses step by step how to create a population data application that is modern, responsive, and ready to use.
Demo Application & Database Access
🔗 Demo Application:demo-app
Username : admin
Password : admin123
📄 Spreadsheet Template Database: spreadsheet
What is a Web-Based Population Data Application?
A population data collection application is a web-based system used to manage citizen information digitally. All data is automatically stored in the cloud so it is safe, easy to access, and can be updated in real-time.
By utilizing Google Apps Script, we can create an administration application that has complete features such as:
- Citizen data management
- Number statistics population
- Grouping data per hamlet
- Recording population mutations
- Storage of important documents
- Login system multi-user
Step 1 — Setting Up a Database in Google Spreadsheet
Google Spreadsheet functions as a data storage center. Create a spreadsheet file then prepare the following sheets:
Population Sheet
Contains the main data on residents such as:
- ID
- Full Name
- NIK
- KK Number
- Place Birth
- Date of Birth
- Gender
- Religion
- Education
- Employment
- RT and RW
- Complete address
- Marital Status
- Status in Family Card
- Category (Hamlet or Mutation)
Document Sheet
Used to save document archives in the form of PDF files, such as:
- Format letter
- Cover letter
- Other administrative documents
Each document is saved in Google Drive and the link is recorded in a spreadsheet.
Sheet User
Used as an application login authentication system:
- ID User
- Username
- Password
- Full Name
- Position
- Photo Profile
A neat database structure will make it easier to manage the application in the next stage.
Step 2 — Create a Google Apps Script Project
After the database is ready, the next stage is to create the application web.
How to:
- Open Google Spreadsheet
- Click the Extensions menu
- Select Apps Script
- Create project new
Google Apps Script allows you to create JavaScript-based applications that connect directly to spreadsheets.
Step 3 — Building the Application Backend
The backend functions to organize the data processing process between the application and the database.
Some important features created at this stage include:
Login System
Verifying the username and password from the User Sheet before the user can access the application.
Data Retrieval Population
Displays all citizen data automatically in the form of an interactive table.
Add and Edit Data
Data inputted via the form will be saved directly to spreadsheet.
Delete Data
Deletes data based on a specific ID to keep the database tidy.
Automatic Statistics
Calculating number:
- Total population
- Number of heads of families
- Number of mutations
- Total document
Upload PDF Document
The uploaded document will be saved in Google Drive and the link will be automatically recorded in the spreadsheet.
Step 4 — Designing the Appearance Application
The appearance of the application is made to be easy to use and looks professional.
Some technologies used:
- HTML for page structure
- CSS for modern design and responsive
- JavaScript for dynamic interactions
- Bootstrap to speed up layout creation
- DataTables for interactive tables
- Chart.js to display charts statistics
Responsive design ensures the application remains comfortable to use both on laptops and smartphones.
Main Features of the Population Data Application
Dashboard Statistics
Displays visual graphs such as:
- Gender comparison
- Marital status
- Education level
- Type job
Resident Data Management
- Full features include:
- Add citizen data
- Edit data citizen
- Delete data
- Automatic NIK validation
- Export data to Excel
- Print report in PDF
Data Grouping Per Hamlet
Resident data can be filtered by region:
- Dusun 1
- Dusun 2
- Dusun 3
Recording Resident Movements
Recording residents who move in or move out so that the data remains accurate.
Document Management Digital
Easy archive storage such as:
- Letter of information
- Administrative forms
- Official documents others
Multi-User System
Access rights can be differentiated:
- Administrators can manage data
- Ordinary users can only view data
Step 5 — Implementing a Security System
Data security is a top priority in administrative applications.
Some security measures that are required applied:
- Input validation before data storage
- NIK duplication checking
- User access rights restrictions
- Document storage on Google Drive
- Session-based login system
Step 6 — Deploy to a Web Application
To make the application accessible online:
- Click Deploy menu
- Select New Deployment
- Select Web App type
- Set access to Anyone with the link
- Click Deploy
After the process is complete, the application is ready to use without additional installation.
Advantages of Using Google Apps Script
Using Google Apps Script has many advantages:
- Free without hosting costs
- Data is automatically saved in the cloud
- Easy to develop according to needs
- Can be accessed from various devices
- Suitable for digitizing administration village
Creating population data collection applications is no longer difficult and expensive. By utilizing Google Spreadsheet and Google Apps Script, you can build a modern, efficient and secure administration system.
Digital transformation helps improve public services and makes it easier to manage data centrally.
Start digitalization now and build a more professional administration system.
