Select Interactive
Internal Web App

2025–Ongoing

Internal Web App

Operations software

MJEC: Internal App & Client Tools

Overview

McMillan James Equipment Company (MJEC) is a Texas-based manufacturers representative for HVAC, mechanical, and building systems across divisions and territories. Coordinating 125+ manufacturers and partners (each with contacts, contracts, locations, divisions, and sales data) had strained operations spread across spreadsheets and disconnected tools. Select Interactive built a two-platform solution: an internal web app for MJEC staff to centralize that data, and a public-facing client tool so field staff can generate branded PDF brochures on demand for the lines they represent. Both platforms launched in 2025 and continue on a quarterly review and release cadence with the MJEC team.

The Challenge

Consolidate manufacturer and partner data (contacts, contract dates, locations, divisions, target and actual sales figures, internal notes) into a single governed system with role-based access, full change history, and the ability for any staff member to produce a polished, real-time brochure without involving the marketing team.

Services

  • Internal Web Application
  • Public Client Tool
  • Document Management
  • Role-Based Authentication
  • Database Versioning & History
  • On-Demand PDF Generation
  • Firebase
  • Microsoft Azure
  • Ongoing Development
At a Glance
125+
Manufacturers and partners managed
Role-Based
User authentication and permissions
Real-Time
On-demand PDF brochure generation
Ongoing
Quarterly review and release cadence

Internal App

One place for every manufacturer relationship.

The internal application gives MJEC staff a structured home for the full scope of their manufacturer and partner data: company details, marketing and sales contacts, active locations, associated divisions and departments, contract start and expiration dates, and both target and actual sales figures. Internal notes and documents are attached directly to each record, keeping institutional knowledge out of inboxes and spreadsheets and inside a system the whole team can access from any device.

Data Integrity

Every change tracked. Every version recoverable.

The app maintains a complete audit log of every edit made to any manufacturer record, capturing what changed, who changed it, and when. Full database snapshots roll on a seven-day cycle, giving the team a reliable disaster-recovery window. Whether a field gets updated incorrectly or a larger issue arises, restoring to a known-good state is a straightforward operation, not a crisis.

Access Control

The right data in the right hands.

User accounts are managed through a role-based authentication system built on Firebase. Administrators control who can view, edit, or manage records, and an activity log provides a clear picture of user actions across the platform. The same auth layer spans both the internal app and the public client tool, keeping the entire system under unified access control while delivering a smooth experience on desktop and mobile alike.

Client Tools

A live brochure in seconds, not days.

Field staff use the public-facing client tool to filter the manufacturer directory by location, equipment type, and product type, then generate a polished PDF brochure on demand. The brochure pulls live data (manufacturer logos, descriptions, and contact information), so every document reflects the current state of the database the moment it is created. What previously required a request to the marketing team and a multi-day turnaround is now a self-service action that takes seconds.

Public Facing

Built to grow with every quarterly release.

The public manufacturer directory gives prospective customers and partners a clean, filterable view of the equipment lines and brands MJEC represents. Both the internal app and the public-facing tool are active development projects. The MJEC team meets with Select Interactive each quarter to review usage, prioritize feature requests, and ship enhancements. New capabilities added since launch include expanded filtering options, additional document types, enhanced reporting views, and improved mobile workflows for staff in the field.

Built With

A modern, full-stack TypeScript platform spanning a managed internal app and a public-facing client tool, both deployed on Microsoft Azure.

  • Azure
  • Firebase
  • Nitro
  • React
  • Shadcn/UI
  • Tailwind CSS
  • TanStack Form
  • TanStack Query
  • TanStack Router
  • TanStack Start
  • TanStack Table
  • TypeScript
  • Vite
  • Zod

Insights

Related articles

Engineering · Tech Stack & Tools · Web Strategy10 min read

When Spreadsheets Stop Working: How to Replace Excel with a Custom Internal Tool

A shared workbook is often where good business software begins. Here is how to tell when it has become a bottleneck, then turn its proven logic into a real-time, role-scoped web application your team can own.

Engineering · Web Strategy11 min read

When Your Process Is the Product: How to Tell It Is Time to Build a Custom Web App

Excel is only one container. Email, shared drives, SharePoint lists, and stitched SaaS tools become load-bearing software without anyone deciding they should. Here is how to tell when the process has outgrown the tool, who that decision belongs to, and what a custom web application actually replaces.

All News

Related

Industry

Services

Previous Project

Arts & Giving Back

Foundation for Contemporary Arts

1,100+ pages in Prismic, a custom Stripe-powered store for donated works of art, and a deep set of admin tools, built with Team and supported continuously since launch.

Next Project

Self Storage & Online Leasing

EZ Storage

A multi-facility self-storage operator moved off a legacy ASP.NET 2.0 site to a ground-up TanStack rebuild, with real-time inventory, pricing, and online lease processing from an integrated storage management API, plus a custom internal reporting and SEO audit dashboard.

Based in Fort Worth & Dallas, TX

Let's build something remarkable.

Start a Conversation
Fort Worth: 817 380 8074