Introduction

You build an asset handover app with ToolJet MCP for a commercial construction equipment store that still tracks tools on paper, so staff can scan a QR code and see who has each item and in what condition. Asset Handover Station turns that workflow into a tablet app that records issue, return, and transfer events from one screen. An agent generated the app, and the result is a structured ToolJet application, data, queries, and interface together, that the team keeps running instead of a screen or a code drop.

Build an asset handover app with ToolJet MCP, the finished application: Equipment List — KPI tiles, category breakdown, recent activity, and a searchable, filterable table with an overdue view

Equipment List — KPI tiles, category breakdown, recent activity, and a searchable, filterable table with an overdue view

Build an asset handover app with ToolJet MCP, the finished application: Item Detail — full movement history with condition photos, and an Asset-Manager-only correction flow

Item Detail — full movement history with condition photos, and an Asset-Manager-only correction flow

Build an asset handover app with ToolJet MCP, the finished application: Scan & Record — QR scan with a manual-code fallback, big Issue/Return/Transfer buttons

Scan & Record — QR scan with a manual-code fallback, big Issue/Return/Transfer buttons

What We’re Building

The first page centers on a large scanner, a manual code field, and the three movement actions. A matched item opens with the asset name, category, current holder, and condition already visible, while an unmatched scan shifts into a compact register form that creates the asset and continues straight into the movement step. The same screen keeps the recipient, condition now field, expected-return date, and photo capture controls close to the confirm action, so the user can finish the handover without moving across the app. The second page turns the log into an operating view with filters, counts, category mix, recent activity, and a row list that opens the full asset history.

  • Big QR scanner with a manual-code fallback
  • Issue, return, and transfer actions from one tablet screen
  • Return photos upload to S3 and stay attached to the movement
  • Equipment list with filters, overdue sorting, and recent activity
  • Hidden item detail view with full movement history

Build an Asset Handover App with ToolJet MCP for Equipment Tracking

Want to build it yourself? Start with the ToolJet MCP repository for setup instructions, supported agents, and everything you need to follow along.

The Consolidated Build Prompt

The real build took several passes, and the requirements are consolidated here into one prompt that could have driven the same app from the start. You can use it as a single-shot spec and reproduce the layout, data model, and handover rules without reconstructing the iterations.

Build a 2-page tablet app for a commercial construction equipment store to replace a paper asset-handover ledger. Use ToolJetDB for two tables: items (code, barcode_value, name, category, status, current_holder, current_condition, expected_return_at) and movements (an append-only log of every issue/return/transfer, with from/to holder, condition before/after, notes, photo_urls, and a corrected/corrected_by/corrected_at trail) — an item’s current state is always derived from its latest movement, never overwritten in place.

Page 1, Scan & Record: a big QR scanner with a manual-code fallback above it. On a match, show the item’s name, category, current holder, and condition immediately. On no match, show an inline register-item form (name, category, condition) that generates a new code and continues straight into the movement step. One screen with three big Issue/Return/Transfer buttons, a recipient field, a condition-now field, an expected-return date picker for Issue, and a 1–2 photo capture step for Return that uploads to S3 and attaches the URLs to the movement record. A single Confirm button submits the movement and returns to scan-ready. Center the register-item form; keep the manual code entry and camera view from overlapping.

Page 2, Equipment List: KPI tiles for total/available/issued-or-transferred/overdue counts, a category breakdown chart, a recent-activity feed, and a searchable/filterable table of all equipment showing current holder and last-moved time, with an Overdue tab sorted most-overdue-first. Row click opens a hidden Item Detail page with the item’s current state and full movement history, each entry showing its condition note next to its photos.

Two ToolJet groups, Operators and Asset Managers. Both can scan/record movements and view full history read-only. Only Asset Managers can correct a mistaken movement record (enforced on the correction query itself, not just hidden in the UI) — correcting the latest movement recomputes the item’s current state. Apply a custom muted theme and seed realistic sample data across all equipment categories and statuses so the app doesn’t demo empty. Keep the app to exactly 2 top-level pages.

How ToolJet MCP Builds the App

ToolJet MCP takes the requirements and works through the item model, the scan page, the list page, the hidden detail view, the queries, and the wiring between them, so the output lands as one structured ToolJet application. Enterprise app building does not end at the interface, because data connections, permissions, deployment, and ongoing change stay part of the job, and the generated app sits on a runtime that carries those where supported instead of leaving you with a codebase to operate yourself. After generation, the path stays open for visual edits and code where a specific rule or layout needs it, which is what keeps the app editable when the handover process changes.

The One Thing That Broke

A QR code scan looked wrong on screen because the decoded value carried trailing whitespace, so the lookup missed the matching item. Trimming the scan value fixed the match, and the same asset now opens on the first scan with the right movement flow.

Data Created

The app ended up with two tables. items stores every tracked asset, and movements keeps the append-only log of issue, return, and transfer events, including condition changes, notes, photo URLs, and correction history. The current holder and condition come from the latest movement instead of a mutable status field, so the scan view and the list view stay in sync.

Page Components What they cover
Scan & Record 26 Scan/lookup, register-unmatched-item, and the issue/return/transfer flow with photo capture
Equipment List 15 KPI dashboard, category chart, recent activity feed, searchable table, and overdue view
Item Detail (hidden) 22 Full movement history with condition photos and an Asset-Manager-only correction flow

What Got Generated

Metric Result
Pages 3
ToolJet DB tables 2
Queries 16
Components 63
Code files to maintain 0
Repair cycles 1
Final validation 0 errors

Industries That Run This

Commercial construction and equipment rental — any company that hands physical power tools, survey equipment, or site laptops between crews and needs an auditable record of who has what and in what condition, without relying on a paper sign-out sheet.

Who Gets Access To The Built App

Operators can scan items, record issues/returns/transfers, and view full item history read-only. Asset Managers get everything Operators have, plus the ability to correct a mistaken movement record after the fact — enforced server-side on the correction query itself, not just hidden in the UI.

Enterprise Features for Your Asset Handover App

An asset handover app handles asset codes, current holders, and return dates. ToolJet covers that governance at the platform layer, so you configure it once instead of rebuilding it in every app.

  • SSO and SCIM: sign in with SAML, OIDC or LDAP, and provision users automatically
  • Role-based access control: scope permissions to the app, the data source, and each query
  • Audit logs: track every login, edit, and approval decision for compliance review
  • Air-gapped deployment: self-host on Docker or Kubernetes so your data stays in your network
  • Multiplayer editing: several builders work on the same app, with versioning and Git sync
  • ToolJet AI inside your own deployment: run the AI features in your tenancy rather than a shared service

Final Takeaways

This build shows that a paper handover ledger can become a working tablet app with scan, record, list, and detail flows tied to a live item log. The useful part is not just the interface, it is the structured application behind it, because the app keeps its data model, queries, and screens together after generation. That matters when the asset rules change, since you can keep editing visually, drop into code for a narrow fix, and rely on the runtime for data and workflow behavior where supported, instead of treating the generated app as a disposable artifact.

Cost and Speed by Model

You can easily build a 4-page app with ToolJet MCP for as little as $0.17 with a lean model (Luna medium), or pay more for the latest flagship reasoning (Sol) if that’s what you’re after. The cost is your call, not a floor we set for you.

Model Credits Minutes Notes
Astra 290 to 550 13 to 16 The most polished pages, when cost matters less
Sol (Recommended) 300 to 650 14 to 22 The best balance of quality and cost for most apps
Terra 85 to 210 5 to 12 The fastest, and best kept to smaller apps
Luna max 35 to 55 33 to 62 The most complete Luna, and by far the slowest
Luna high 25 to 50 22 to 41 Mid-effort Luna, between medium and max
Luna medium 10 to 30 14 to 20 A quick first draft or a small tool

Three to four builds per model across four-page apps. 1 credit = 1 cent. Credits and time are estimates only and will vary with the complexity of what you ask for. This measures cost and speed only, not how complete or polished the result is.

Even averaging across model tiers, ToolJet MCP can turn $10 into a dozen or more working 4-page apps.