Appointment and Patient Tracker

[stevedowman]

Hi everyone,
I built a Clinic Appointment & Patient Tracker in LiveCode to manage a small practice’s daily workflow, using a local SQLite database with tables for patients, appointments, and visit_notes, all linked through unique IDs. The interface is a multi-card stack where the main calendar view displays appointments by date, and selecting a slot opens a detailed form with patient info, visit reason, and status (scheduled, completed, cancelled). I implemented time-slot validation to prevent double booking, and a script that automatically highlights missed appointments and follow-ups. Patient records include history logs that append each visit note with timestamps, making it easy to review past treatments. I also added search and filter functions for quick lookup by name, phone, or date range, plus a simple export to CSV for reporting. The app runs fully offline, and I optimized load times by only querying records for the selected day instead of the full database. Next, I’m planning to add SMS/email reminders and a lightweight sync feature between front desk and doctor devices. I am curious if anyone has tried handling real-time updates within LiveCode stacks?

[dunbarx]

I got in trouble a while ago assuming that a bot had written a post here.

@Steve. Hi?

Craig

[stam]

I am curious if anyone has tried handling real-time updates within LiveCode stacks?

updates for what? the app?
Yes - you could look at theSparkle framework for updates.
Or roll your own, you can access stacks online and download them.

I'm more curious about the choice to use sqlite - something like mysql would seem better as you can share with multiple workstations or remotely? SQLite limits you on this front.