Family Dental Clinic Patient Records
For Family Dental Clinic
A single-screen Windows desktop application for Family Dental Clinic's patient records — Excel as source of truth, SQLite as local cache.
Context
A Windows desktop application for Family Dental Clinic’s patient records, with live-search lookup and chronological visit history. Excel serves as the source of truth, with a local SQLite cache — an arrangement set up to migrate toward SQLite as the primary store.
Scope
Embedded Crew built a single-screen Windows desktop application for the clinic.
The sidebar lists patients with live search; selecting one shows every visit in chronological order. New patients and new visits queue in a Pending Sync panel until the clinic explicitly synchronizes back to the workbook. At sync, the application re-reads the Excel file, applies exact-normalized duplicate detection, assigns medical record numbers based on current row count, and appends the new rows.
Result
The application is complete and ready for deployment at Family Dental Clinic.