Build a Patient Flow Board With ToolJet MCP for Bed Managers

Описание и применение

Создана живая панель управления потоками пациентов в ToolJet MCP для 600‑местной больницы, объединяющая данные о поступлениях, занятости, выписках и задержках в три страницы с автоматическим обновлением каждые 5 минут.

Задача

Hospital bed managers need a live, consolidated view of admissions, occupancy, discharges, and delay trends to make timely decisions, but printed reports become outdated quickly.

Результат

The generated app contains 3 pages, 13 database tables, 26 queries, 52 components, and zero code files to maintain, with two repair cycles to fix a seed‑logic bug.

Рабочий процесс

• Gather live ward census and movement feed
• Group discharge reasons across the queue
• Calculate occupancy, waits, and the eight‑hour projection
• Rank the queue by total delay hours
• Review weekly delay trends and adjust priorities

Доказательства

The first weekly check showed the same admissions total every day, so the trend chart looked flat and wrong. The cause was a random filter that PostgreSQL evaluated once per ward instead of once per generated day. Reworking the seed logic fixed the pattern.

Источник

ToolJet MCP works through the whole application, from the data model and queries to the pages, components and wiring, and creates a structured ToolJet application inside ToolJet rather than handing back a codebase for you to assemble yourself or export into another build flow.

Источник