coddcore
<- Back to journal

15 Oct 2025

Building a Simple Calendar Assistant Application

An overview of a simple calendar assistant I built — allowing users to create, manage, and organize events through a clean interface backed by a database.

Building a Simple Calendar Assistant Application

Built this tool to simplify my workflows as an agent in Safaricom. Time schedules are provided on a web portal but you need to frequently visit the portal to spot your breaks and lunch as well as training and coaching sessions. I felt like the integration is long overdue and needs to be directly integrated to personal or work calendars such that I would never need to add them personally to my calendars and even better, never have to access the schedules from the portal. I have included a sample time sheet on Google Drive that will allow you or anyone to test drive the application using a sample time schedule. Application Link: https://safaricomcalendarassistant.streamlit.app Time Schedule Link: https://drive.google.com/file/d/1hyKCmsg3JI0DEL5YZReslze0f0HhdHpT/view?usp=share_link

I built a simple Calendar Assistant application that:

  • Allows users to add and manage events
  • The schedules are ideally stored in a database and could be accessed via CRUD
  • Displays upcoming activities clearly and user has the ability to add them to calendar
  • Handles basic time-based organization

In this post, I’ll walk through what the app does, how it’s structured, and the key concepts behind building a functional scheduling system.

Table of Contents

What is a Calendar Assistant?

A calendar assistant is a system that helps users:

  • Schedule events and appointments
  • Track deadlines and reminders
  • Organize daily, weekly, and monthly activities

At its core, it involves:

  • Time-based data storage
  • User-friendly interfaces
  • Reliable backend processing

Project Goal

The main goal of this project was to create a basic but functional calendar assistant that demonstrates:

  • CRUD operations (Create, Read, Update, Delete)
  • Time and date handling
  • Database-backed scheduling
  • Clean application flow

Application Overview

The app provides users with a simple interface where they can:

  • Add a time schedule document and get calendar events that can be added to a calendar without manually doing so.
  • View upcoming schedules

Once an event is submitted, it could be stored in a database but can be displayed in the calendar view.

System Architecture

I would ideally upload the timeschedule to the assistant. Character reading abilities of the assistant would extract the contents of the time schedule and present them in an excel like format after which they can be converted to calendar format and can be downloaded to a device.

Challenges Encountered

In the event that schedules are not fixed and that changes need to made even after they are released, its difficult to integrate them seamlessly as there would be already added calendar events that would need to be deleted. An idea to have all these schedules as push notifications instead of adding them directly to calendars which would eliminate the need to manually add the time schedules but have a direct link from the time schedule database to the notification system expressly through CRUD API system.

Final Thoughts

For a moment, this actually worked for me until I realized that maybe I just needed a better notification system for the time schedules. I went back to just opening the time schedule portal but with a desire to improve the experience for myself. Not sure if there are any colleagues who would need the experience enhancement but I feel there's room to improve on processes or even experiences.