Skip to main content
Back to cases
AdminWindows app

Visitor Log Helper

Replace the paper visitor book with a small local app: name, company, host, in/out times — searchable forever.

The problem

Paper visitor logs are illegible and a pain to summarize. "Who visited us last month?" becomes a chore.

The solution approach

A local app: a few fields on check-in, auto in-time; one-click check-out; monthly export.

What you will end up with

  • Reception form: name, company, phone, host, purpose -> check-in.
  • Right pane: live "currently in" list; click to check out.
  • Today / week / month stats cards.
  • Export by month to Excel.

Ready-to-use prompt

You are a senior engineer building local desktop tools. The user is the company receptionist/admin, non-developer.

[Goal]
Make visitor logging fast and reliable; monthly stats in one click.

[Platform & Stack]
- Windows + macOS; Electron + React + TypeScript; local SQLite

[Core Features]
1. "New visitor" form on the left: name, company, phone, host (dropdown), purpose, notes -> submit creates an "in-house" record with in-time.
2. "In-house" right list: each row has check-out button -> records out-time and moves to "today".
3. Top stats: today / in-house / week / month.
4. History search by date range, name, company, host.
5. Employee list (host candidates) locally managed; Excel import supported.
6. Monthly export Excel.

[Visual Style]
- Light background, white cards, radius 16, generous whitespace.
- Primary button muted dark; secondary light gray.
- Follows system dark mode; system fonts.

[Robustness]
- All data stays on the local machine. Offline.
- Autosave; 7-day rolling backups.
- Friendly messages on bad input, never raw stack traces.

[Delivery]
1. Outline project structure + plain-text wireframe first; wait for confirmation.
2. Deliver in modules; run each one for me to see.
3. Package a Windows .exe and macOS .dmg, ship a 500-word plain-language user guide, list known limits.

Start with structure and wireframe.

After copying

1

Open Codex Desktop and create a new project

2

Paste the prompt and send

3

Wait for Codex to finish; tweak company names, column names, button text as needed

More cases from this department