Internal Tools & Field Portals — TCG Software Works

Two patterns, depending on where the work happens

Internal admin / CRUD app

For when "the spreadsheet" no longer cuts it. Multi-user editing, audit history (who changed what when), search, exports, mobile-friendly forms. Replaces the shared Excel file someone keeps overwriting.

Common builds: client roster + intake form, work-order tracker, employee-cert log, equipment inventory + assignment, training-completion tracker, customer-complaint log.

Phone-first internal portal

For field staff who use the tool from a phone in a parking lot. Clock-in / clock-out, photo upload, GPS-stamp, signature capture, daily-briefing view. Offline-tolerant; syncs when connectivity returns.

Common builds: contractor punch-clock with GPS, delivery-driver POD signature capture, technician work-order completion, daycare check-in/out.

What makes these different from off-the-shelf SaaS

You own the source. Day-one git handoff. No SaaS subscription, no per-seat fee, no upcoming-shutdown announcements.
Built for your specific workflow. Off-the-shelf tools have 200 features you don't use. These have the 12 features you actually need.
Audit history is the default. Every change records who-what-when. Most off-the-shelf tools charge extra for this.
Role-based access — your owner sees everything, managers see their location, employees see only their assignments. Configurable without code changes.
Hosted on your subdomain — e.g., portal.yourbiz.com. Looks like part of your business, not a third-party tool with a generic URL.
Documentation written for the operator, not for a developer. Two-page runbook covering: how to add a user, how to back up, how to export data, who to call if something breaks.

What about the database?

SQLite for small builds (up to a few hundred thousand rows). Single file, easy to back up, runs anywhere.
PostgreSQL for builds that need concurrent writes from many users or that will grow past the SQLite ceiling.
Restore-tested backups — nightly automatic, weekly verified by a sandbox restore. The backup is on your server (or in your cloud bucket); we don't hold it.
Export to CSV / Excel from the UI by default. You're never locked in.

Pricing

Small CRUD app: from $1,500. Single-table CRUD with auth, search, exports. 1-2 weeks. Common for "we just need to track X without a $50/mo SaaS bill."

Medium internal tool: from $4,500. Multi-table relations, role-based access, audit history, mobile-friendly forms, scheduled reports. 3-5 weeks. Most replace-the-spreadsheet builds land here.

Field portal with offline: from $5,500. Phone-first UI, GPS stamps, photo uploads, offline queue + sync. 4-6 weeks.

Start an internal-tool build ← Back to Software Works Call 812-414-9097