Your Swansea ops run on six Retool screens and one finance spreadsheet nobody is allowed to touch
Custom internal tools for a Swansea operation run £25,000 to £75,000 over 2 to 5 months. Retool, Airtable, and spreadsheets get you a long way, until the tool has to enforce a rule rather than display a table. The moment matters in South Wales because the rules that bite are grant-eligibility checks, bilingual record-keeping, and works-floor data from a metals or manufacturing line that no off-the-shelf admin panel understands. A custom tool encodes the logic, not just the view, so the spreadsheet stops being the thing the whole operation secretly depends on.
You wired up Retool over your database and it was genuinely great, fast CRUD screens, a few dashboards, no months of work. Then the requests got harder. Finance wants a screen that flags when a cost is ineligible against a Welsh Government grant. The works floor wants to log a heat or a batch in a way that ties to the funded equipment. Someone needs the whole thing in Welsh as well as English. Retool can query, but it can't hold that business logic without becoming a tangle of half-readable JavaScript that one person understands.
So the important rules stay in a spreadsheet with colour-coded cells and a macro nobody will touch, and that spreadsheet quietly becomes the most critical system you own. Airtable hits the same ceiling: lovely until you need real validation, an audit trail, or a workflow that enforces a grant rule rather than suggesting one. The tool that was supposed to save you turns into the thing you're afraid to change.
Where the off-the-shelf tools fall short
- Retool screens display your data fine but can't enforce grant-eligibility or milestone rules, so the real logic lives in a fragile spreadsheet
- Bilingual Welsh and English internal records are unsupported, so staff maintain two versions by hand
- Works-floor data from a metals or manufacturing line doesn't fit a generic admin panel and gets keyed in twice
- Airtable and spreadsheet 'tools' have no audit trail, so when a grant figure is questioned nobody can say who changed what
Custom internal tools: what Swansea teams actually get
You go custom when the tool needs to enforce rules, not just show rows. A Swansea build puts grant-eligibility logic, bilingual records, and works-floor data capture into a tool with real validation and an audit trail, so the spreadsheet that everyone fears can finally be retired. The custom case is tight: you are not rebuilding Retool, you are replacing the handful of screens where the business rule is the whole point and the low-code tool quietly gave up.
- Your most important logic lives in a spreadsheet because Retool or Airtable can't enforce it
- A grant or finance figure has been questioned and nobody could prove who changed it
- You need bilingual internal records the low-code tool can't produce
- Works-floor data is being keyed in twice because no tool captures it cleanly at source
- Your internal needs are genuinely CRUD screens over a database
- Retool or Airtable already does the job and no critical rule is hiding in a spreadsheet
- You don't have a developer relationship to maintain a custom codebase
- The data isn't sensitive enough to need a real audit trail
- Business rules, grant-eligibility, milestone gates, batch validation, enforced in code instead of remembered by one person
- A real audit trail on every change, so a questioned grant figure has a name and a timestamp behind it
- Bilingual Welsh and English records native to the tool, not maintained as two parallel spreadsheets
- Works-floor data captured once, at source, and tied to the funded equipment or the job it belongs to
- The fragile colour-coded finance spreadsheet retired, with its logic now testable and owned
- You lose Retool's speed for the next quick screen; new tools are now a small build, not a drag-and-drop afternoon
- Someone has to maintain the codebase, so you need a developer relationship, not just an admin
- Over-building is a real risk; not every screen deserves to leave Retool and a good team will say so
- If your needs are genuinely just CRUD, custom is more than you need and low-code stays the right call
Feature priorities for Swansea teams
Swansea internal tools: the full scope
The engagements Swansea teams bring us most often: approval workflows, internal portal, business process automation, data-entry tools, admin panel development, internal dashboards and Retool alternative.
The honest cost picture for Swansea
| Project scope | Typical cost | Timeline |
|---|---|---|
| A few rule-enforcing screens replacing a critical spreadsheet | £25k to £40k | 2 to 3 months |
| A suite of internal tools with audit trail and bilingual records | £45k to £75k | 3 to 5 months |
| Works-floor data capture tool tied to ERP | £30k to £55k | 2 to 4 months |
Timeline: what happens, and when
Exactly what you get
Internal tools that enforce your Swansea-specific rules instead of just displaying rows. Concretely: rule-enforcing screens for grant eligibility and milestones, a real audit trail, bilingual Welsh and English records, works-floor data capture tied to jobs and funded equipment, and role-based access. You keep Retool for the genuinely simple CRUD and replace only the screens where the rule is the point. It integrates cleanly with your ERP, accounting software, and business intelligence dashboards so data is entered once and trusted everywhere.
How to choose a developer in Swansea
Find a team that asks which spreadsheet you're afraid to change before they quote anything. That spreadsheet is usually the real project. A good partner will tell you plainly which screens should stay in Retool or Airtable and which need a real build, because over-engineering internal tools is the classic way to waste money. Ask how they handle audit trails and bilingual records, and watch for anyone who wants to rebuild your whole stack when three screens are the problem. The same restraint marks a good custom software or project management software build.
- !They say everything can stay in Retool; ask how it enforces a grant-eligibility rule with an audit trail
- !No mention of validation or change history; ask what happens when a finance figure is challenged
- !They ignore the bilingual requirement; ask how Welsh and English records stay in sync without manual work
- !They want to rebuild your whole stack; ask which screens actually need to leave low-code and which don't
- !No integration plan with your ERP; ask how works-floor data reaches the books without double entry
If internal tools is on the roadmap, custom software, wordpress, accounting usually follow within the year. Budget them as one conversation.
Rohan advises mid-market and enterprise teams on ERP, CRM and custom software, and has led delivery on dozens of business-software builds.
Writes for Digital Heroes, shipping business software for 2,000+ brands across 55+ countries since 2017.
Frequently asked questions
Can't we just keep extending Retool?
For CRUD and dashboards, yes, keep it. The wall comes when a tool must enforce a rule, like blocking a grant-ineligible cost, with validation and an audit trail. That logic ends up as fragile in-app JavaScript or, worse, a spreadsheet macro one person owns. A custom build replaces just those screens while you keep Retool for everything simple. It's a targeted swap, not a rip-and-replace.
How is a custom tool better than our colour-coded spreadsheet?
The spreadsheet has no validation, no audit trail, and no way to stop someone breaking a formula. When a grant figure is questioned, you can't prove who changed what or when. A custom tool enforces the rule at entry, logs every change, and can be tested. For anything a funder might audit, that difference is the whole reason to build.
Do we need bilingual internal tools, not just customer-facing ones?
If staff or partners work in Welsh, yes, otherwise people maintain two versions by hand and they drift. Building bilingual records into the internal tool keeps one source of truth in both languages. For purely English-speaking back-office work it's optional and the build scopes it out, but in Swansea it's commonly worth it.