Kelvin Loh Dot Click | Python Desktop, Web & Data Automation

Learn how to build a Flask-Admin management dashboard that reads booking data from SQLite, uses Pandas to analyze bookings and revenue, and presents key business metrics and charts for management.

  A booking system should do more than simply create reservations. In this tutorial, we'll enhance the Jersey City Pickleball Club booking system by allowing members to edit their court, date, and time slot, download a revised entry pass after making changes, and automatically remove bookings once their scheduled time has passed. Using Flask, TinyDB, and the existing Stripe payment integration, we'll turn the basic booking workflow into a more complete and practical booking management system. Prerequisite: This tutorial is part of the Flask Landing Page and Reservation System Series. 📚 View the Complete Flask Landing Page and Reservation System Series ⬅ Previous Part                                                                                          ...

In this tutorial, we will enhance our Flask-based Jersey City Pickleball Club booking system by adding two useful features: a PDF entry pass and Stripe payment receipt access. We will use ReportLab to generate a personalised entry pass containing booking details such as member name, court, date, time slot, and booking fee information. We will also integrate with the Stripe API to retrieve the official payment receipt, allowing users to access their transaction records directly from the dashboard. Prerequisite: This tutorial is part of the Flask Landing Page and Reservation System Series. 📚 View the Complete Flask Landing Page and Reservation System Series ⬅ Previous Part                                                                                           ...

Accepting online payments is only half the job. A complete booking system should also record every successful payment in my accounting software without requiring manual data entry. In this tutorial, you'll learn how to integrate Stripe with a Flask application to securely accept online payments and automatically create sales receipts in QuickBooks Online. By the end, the Jersey City Pickleball Club booking system will process payments, keep financial records in sync, and provide a solid foundation for generating receipts and reports, as well as future business automation.

Booking systems are one of the most practical web applications you'll encounter, whether it's for sports facilities, meeting rooms, or appointment scheduling. In this tutorial, you'll build a complete pickleball court booking system using Flask , TinyDB , Flask-Login , Flask-WTF , Bootstrap , and HTMX . Users will be able to search for available courts, select an available time slot, confirm their reservation, and instantly see their bookings displayed on a personalised dashboard. Along the way, you'll learn how to create a smooth, modern user experience with partial page updates, form validation, and a lightweight NoSQL database—without relying on a full-page refresh.