🏗️ Project Overview: Lead-Based Paint Testing SaaS Platform

Welcome to the official project channel! Below is a detailed overview of what we’re building, what exists today, and where we’re headed 🚀

🧩 Current Application Status

Our existing system is fully powered by Airtable and serves a lead-based paint testing company. It handles:

• 🧑‍🤝‍🧑 Client records
• 👷 Inspector assignments
• 📋 Forms and inspection queues
• 📊 Dashboards for internal use

However, this Airtable-based setup is limited in scale and flexibility:

• Only one company/entity can use the platform at a time.
• Cloning the base for each new company is not scalable – data from one entity carries over to others.
• There is no isolation, no subdomain whitelabeling, and no real multi-tenancy.

🎯 The Goal

We're turning this single-tenant Airtable app into a multi-tenant SaaS product, complete with:

• 🌐 Subdomain-based access for each subscriber e.g., acme.mysaasapp.com and brightsolutions.mysaasapp.com
• 🏢 Isolation of data between companies (tenants)
• 🧑‍💼 Each subscriber can:
  • Manage their own clients
  • Add/assign inspectors
  • Organize job queues & inspection forms
  • View data via dashboards tailored to their workflows
• 👑 We (the owners) only handle the administration of subscribers, not their internal client data.

⚙️ Tech Stack

We’ll build this from the ground up using: