iOS App Development for AKPSI
May 2023 - Dec 2024
The Problem:
As a member of AKPSI, a professional business co-ed fraternity, I helped the team with many of the data management & tech-related tasks. While doing this, I quickly noticed a glaring problem with their alumni database - as more and more data accumulated, it became cumbersome and inefficient to use.
The team maintained their database on Google Sheets, listing detailed information such as student names, contact details, companies, and addresses.
The lack of user-friendly search and filter options, coupled with the static nature of spreadsheets, makes it challenging for users to quickly find specific alumni details or view overarching trends. The system also hindered smooth communication and outreach efforts, which led me to propose a more streamlined and intuitive solution.
The Old Database:
My App Walkthrough:
The Solution:
In response to the problem, I developed and integrated a user-friendly app that seamlessly navigated and interacted with the alumni data we already had. This app was directly connected with Google Sheets using a custom app script, pulling in all the data in real-time. Here's a brief overview of the main features:
User Authentication: Secure login to ensure only authorized personnel can access alumni information.
Search Functionality: Users can easily search for alumni based on various criteria like name, company, location, etc.
Interactive UI: A clear and concise list view of alumni, with an option to click and get a card view for more visual representation.
Filters & Tags: This would allow users to filter results based on specific criteria like industry, location, pledge class, etc.
Contact Integration: A click-to-contact feature for quick emails or phone calls directly from the platform.
The Process:
This app integrates with the Firebase API, enabling users to sign in via Google and access real-time data from a constantly updated database. I've structured it using the MVVM architecture, making the code organized and maintainable.
The app also seamlessly interacts with the Google Sheet. Using various SwiftUI components, like 'Searchable', 'Navigation Links', and 'ASYNC' calls, it fetches this data and displays it in a user-friendly list. Plus, if you're looking for something specific, there's a handy filter option!
Figma Mockups:
Backend Development:
Since I created the app from scratch, it required me to not only develop an easy-to-use front-end user interface but also a more complex back-end structure that accommodated our security needs. Feel free to explore my GitHub to see the detailed code behind it all!