All Tables
Your raw database โ one tab per table, like a spreadsheet with sheets. Click a header to sort, type under it to filter. This is the "let me see the flat tables" view.
New Referral โ Application for Home Repair
The full intake form. Fields marked * are required; everything else is optional. When you edit an existing client, their details fill in automatically. No Social Security number, by design.
New Client Interview
Pick an existing client (or type a new name to create one), then fill in the interview. Falls & ER are the required funder numbers โ if none, enter 0.
Clients
One row per client โ the flat table you asked for. Click any column header to sort, type in the boxes under each header to filter. Click a row to pop out the full record. Double-click a County, City, or DOB cell to edit it right here โ saves in this browser.
Projects
The build pipeline. Sort by any header, filter under each column. Change Status or Hold right in the table โ every change is logged. Double-click Work, County, Town, a date, Vols or Hours to edit it inline โ saves in this browser.
Reports
Your Current Project Update, plus a report builder โ pick the table, choose the fields, table or chart, name it and save it. Totals compute live, never hand-typed.
Click โ New Referral. Fill the form top to bottom (starred fields are required). Click Save.
Click ๐ฉบ New Client Interview, search & pick the client, complete it, Save. Falls & ER questions are required.
๐ฅ Clients โ search โ click the row to open, then โ Edit client. Or double-click a cell to quick-edit.
Open a client โ Attachments tab โ ๐ Attach a file (referral PDF, deed, photos โ up to ~15 MB).
๐ My View shows your projects โ e.g. upcoming site visits. Sign in (top-right) to see yours.
๐ซ Issues & requests โ type it โ Submit. Your admin replies there; status flips to Resolved. No email needed.
๐ Reports to build/print. ๐ฃ Public stats is safe to share โ totals only, no names.
๐ All Tables โ ๐ Archive backup downloads a copy anytime. It never deletes anything.
All Tables shows records used against the 1,000-record limit, and warns you long before you get close.
Tap โฌ Add to home screen for an app icon. On phones the menu is the โฐ button, top-left.
Submit an issue or request
Teams & Agencies
Your canonical lists. Click a name to open its contact card โ who to phone, email, notes. Add or rename here; they're dropdowns everywhere else.
Sponsor teams
Referral agencies
Settings & Users
Everything is on by default, as you asked. Flip any module off with one switch; turn it back on anytime. Manage who gets in and what they can do.
Features โ on by default
๐จ Theme
Pick a look for this device. Your choice is saved on this browser โ each user can set their own.
๐ Passcode gate
Login & access
Users
About this system & your data
What this is
A free case system for Rivertown Community Repair Mission โ no login, no monthly fee. Everything you enter saves automatically in this browser on this computer. That's ideal for one person entering data and for showing the team how it works. When 3โ4 people need to share one live copy, this same design becomes a shared database the mission owns; your Export file loads straight into it.
Your data โ always yours
Loaded with sample data so nothing's empty. Reset restores it for a clean demo.