Databases

ADU Loan Program Management Database, OCHFT

We designed and built a custom Airtable solution for the Orange County Housing Finance Trust to manage a new ADU loan program. While the program itself was canceled, the database became a powerful tool for market research, successfully collecting and sharing valuable data on regional ADU demand that was used by local governments to inform their housing policies.

Program management, operations, and reporting software, Orange County United Way

We revolutionized case management for the WelcomeHomeOC program by consolidating 35 disparate data sources into one powerful Airtable Command Center. This custom solution slashed housing matching times from 90 minutes to under 5, eliminating manual data entry and expanding their client capacity from 30 to over 500, fundamentally transforming their ability to connect vulnerable individuals with housing.

Funder & Trust Compliance Requirements Database, OCHFT

Imagine being overwhelmed by a sea of compliance documents, with critical requirements scattered across dozens of PDFs and templates. That's the challenge a recent client faced when trying to manage nine different funding tranches, each with its own complex rules. We stepped in to create a custom Airtable database that consolidated all 145 requirements into a single, searchable source of information. Now, instead of endless searching, they can instantly surface exact terms, filter by funding source, and condense hundreds of pages into a clear, actionable list—transforming their compliance terms from chaotic to controlled.

Funded Affordable Housing Project & Grant Database, OCHFT

We helped the Orange County Housing Finance Trust move beyond static charts to a dynamic Airtable database, revolutionizing how they track grants, monitor projects, and showcase their significant impact on affordable housing.