FastOrg

Poster

Inspiration

My inspiration for this project was the countless hours I spent as president and the countless hours my friend Caden spent as the president before me putting members of our organization in one by one into a handful of different softwares. I realized there had to be a better way to neatly organize all of your organizations members in a way where you can easily generate lists, pull data, and sort members by categories. We wanted to create a project that would allow presidents of other organizations to get these resources easily and efficiently so they can focus on more important things like running their organization.

What it does

FastOrg allows organizations to create organizations, manage members, and retrieve specific data using natural languages queries. Our application makes data management for organizations intuitive and user-friendly.

How we built it

We utilized FastAPI for the backend, MongoDB for data storage, and React for the frontend. Auth0 handles authentication, while OpenAI API processes natural language queries and converts them into MongoDB queries.

Challenges we ran into

One of the biggest challenges we ran into was integrating Auth0 authentication into our backend and session management for admin/owner accounts. Additionally, we ran into many bugs when handling real-time data updates efficiently from frontend to backend and vice versa.

Accomplishments that we're proud of

We managed to pave the way for a system of generating query language though GenAI on a connected database. Also, we managed to create a seamless and secure authentication flow with relational databases active for each user. Overall, the biggest accomplishment was cohesively working together as a team, successfully learning and integrating new apis and plugins such as Auth0 and MongoDB.

What we learned

We learned the importance of integrating backend and frontend systems and implementing a user-friendly AI integration system. We also learned a lot about MongoDB query optimization, API calls, and using Auth0 to efficiently handle authentication and security.

What's next for FastOrg

The next step for FastOrg is to improve our AI model and our current DeepConsole integration in our application. We want to finetune and optimize the workflow from natural language to MQL queries to get more accurate data queries. We would also want to implement role-based access controls to restrict and manage member/admin permissions. Additionally, we could develop a mobile version of our app.