BuildFlowCRM

A commercial real-estate brokerage was running on spreadsheets. They deal in five kinds of property (warehouses, corporate offices, coworking, retail and managed offices), and each has its own fields, so one flat property table didn't fit. Several people edit the same records, and the owners wanted to review changes before they went live.

Each kind of record has a base schema, and Mongoose discriminators add the fields specific to each property type. A coworking listing has seats and setup fees, and a warehouse has docks and floor area, but they share one collection and one set of validation rules.

When an employee edits or deletes something, the change isn't applied. It becomes a pending action assigned to their manager, and the record shows as under review until it's approved. One collection holds pending actions for every kind of record through a dynamic reference.

Everything can be exported to Excel and imported back with validation. Documents upload to Cloudflare R2, and the API runs behind JWT cookie auth, helmet and rate limiting, tested with Vitest and Supertest.