Govern a Base Like an Internal Product
A spreadsheet updated by hand every Monday, a base built one evening that became critical: most business tools are born without an owner or rules. As long as nobody answers for them, they are not tools that last — they are shadow IT on borrowed time.
TL;DR
- Shadow IT and internal products differ by four artifacts, not by the tool: a named owner, written naming conventions, a periodic review, a changelog.
- In late 2022, Gartner forecast that 80% of low-code tool users would sit outside formal IT departments by 2026, up from 60% in 2021.
- Kaspersky study published in late 2023: 11% of companies worldwide suffered a cyber incident caused by shadow IT.
- An Airtable base's revision history lasts from 2 weeks to 3 years depending on the plan (verified August 12, 2026): only a team-maintained changelog never expires.
- Airtable documents base structure, but publishes no naming convention: that standard belongs to the team governing the base.
- One review hour per quarter, with the template at the end of this article, is enough to keep a base healthy.
Shadow IT is a status, not a tool
This article's thesis, refutable in one sentence: a base a team depends on deserves what an internal product gets — an owner, conventions, a review, a changelog. If yours has run for three years with none of this and no incident, you hold a counterexample. And you got lucky.
Almost all of our projects start in the same place (Ownward internal data, 2026):
- an Excel file updated by hand every Monday;
- a spreadsheet used as a database;
- dashboards sent as attachments.
Decisions rely on them every week — and nobody answers for them.
Research points the same way: a systematic review of 77 papers published in 2020 in Information Technology and Control identifies shadow IT's causes — filling gaps in official systems, slow IT response times — and its risks: inconsistent data, undocumented and unmaintained systems. The risk does not come from the technology, but from the absence of an owner and documentation.
And the phenomenon is scaling up: in late 2022, Gartner forecast 80% of low-code users outside formal IT departments by 2026, up from 60% in 2021. Banning is a losing game. Realistic no-code governance starts lower: giving every base that matters product status.
A named owner, not a de facto one
We have described elsewhere the governance program at the organization level. This article covers the level below: the practice on one base, which can be set up in a week without waiting for the program.
First artifact: a name. Not "the team", not "the person who built it and left": one person, written into the base description, who arbitrates field requests, approves structural changes, and keeps the changelog. Microsoft's documentation on Power Platform Centers of Excellence (updated May 2025) makes this an explicit recommendation: named owners, naming standards, least-privilege access, regular audits.
Goodwill already exists: in a 2021 Gartner survey of 2,820 business technologists, 76% said they take responsibility for the risk of what they build. What is missing is the frame that turns diffuse responsibility into an explicit role. Three lines, pasted into the base description:
Owner : first.last — arbitrates structure & access
Deputy : first.last
Review : quarterly · changelog: _CHANGELOG table
Naming conventions: fill the gap
Airtable's official documentation frames structure well: one base per workflow, views rather than a proliferation of tables, a primary field that is "informative, unique, and short". But — verified on August 12, 2026 — it publishes no naming convention for tables, fields, and views. That standard is left to the team. Which is an opportunity: write yours on one page. Ours is versioned and applied across 30+ projects delivered inside our clients' tools (Ownward internal data, 2026). The transposable principles:
| Object | Rule | Example |
|---|---|---|
| Table | Plural noun, no date or version | Contracts, not Contracts 2025 v2 FINAL |
| Computed or linked field | Type prefix | fx_Margin, lk_Client |
| View | Consumer + purpose | OPS – Weekly follow-ups |
| Technical table | Underscore prefix | _CHANGELOG, _CONFIG |
| Automation | Verb + trigger | Notify – contract signed |
Adopt these rules or your own. What matters: they are written, dated, and a newcomer can find any object in under a minute. A naming convention is to a base what the schema is to the project: the invisible deliverable that conditions the others.
A changelog, because native history expires
Airtable's revision history is retained for 2 weeks on the free plan, 1 year on Team, 2 years on Business, 3 years on Enterprise Scale (verified August 12, 2026). That is a good safety net for data. Not for structure: the "why" behind a renamed field does not survive the plan's retention window.
Software engineering solved this long ago. Keep a Changelog fits in one sentence — "Changelogs are for humans, not machines" — and six categories: Added, Changed, Deprecated, Removed, Fixed, Security. Semantic Versioning adds the grammar: an incompatible change is major and gets announced beforehand. Transposed to a base: renaming a field referenced by an automation or a dashboard is a major change — it is announced, not discovered. Concretely, a _CHANGELOG table inside the base itself:
Date · Version · Category · Description
2026-08-03 · 2.4.0 · Added · fx_Margin field on Contracts (finance request)
2026-07-01 · 2.3.0 · Deprecated · "Old pipeline" view — removal in Q4
Cost: one line per structural change. Value: the only history that depends on neither the plan nor the platform.
Quotas documented as product constraints
An internal product knows its operating limits; governing an Airtable base means knowing yours. As of August 12, 2026: 1,000 records per base on the free plan, 50,000 on Team, 125,000 on Business, attachments from 1 to 100 GB depending on the plan. These are not flaws, they are parameters. The product reflex: write them into the base's fact sheet along with current volume, to decide before being decided for — one of the principles of how we build. Since the centralized admin panel arrives with the Business plan, below it, visibility rests on the team's discipline.
A base governed this way can carry much more than records. At one client, the full configuration of a synchronization engine connecting six CRM/ERP systems lives in a base: adding a source means adding a mapping, not writing code (Ownward internal data, 2026). That level of trust is built with this article's four artifacts.
What doing nothing costs — In 2020, nearly 16,000 positive COVID cases vanished from England's contact tracing: the Excel files had hit their row limit; researchers estimated (2021) that at least 1,500 deaths are linked to it (EuSpRIG). In January 2024, one wrong date in a spreadsheet cost Norway's sovereign wealth fund about $92M. The common thread: critical artifacts nobody governed.
The quarterly review template
One hour per quarter: the owner, a key user, a technical eye if available. Each item produces at most one action, logged in the changelog.
| Review item | Question | Typical action |
|---|---|---|
| Ownership | Owner and deputy still in post and on board? | Update the base description |
| Access | Who has creator or editor rights, and still needs them? | Downgrade to least privilege, remove leavers |
| Naming | Have off-convention objects appeared? | Rename (announced in the changelog), archive orphan views |
| Volumes and quotas | Where do we stand against plan limits? | Project the saturation date; archive or upgrade the plan |
| Automations | Do they run? What would a rename break? | Document dependencies, disable the obsolete |
| Duplicates | Is the same data entered twice anywhere? | Replace with link + lookup, or synchronize |
| Changelog | Up to date since the last review? | Backfill entries, bump the version |
| Product status | Integrate, renovate, or monitor? | Decide explicitly — the three outcomes of the 2020 academic framework |
This last item is the most important: a review can conclude that the base has outgrown its frame. A weekly dashboard maintained by hand every Monday became, at one of our clients, a full multi-tenant application (Ownward internal data, 2026). The normal trajectory of an artifact that matters.
The limits of this approach
This practice is only worth it for bases that matter. Applied to every ephemeral spreadsheet, it becomes bureaucracy and will be bypassed — triage is the first act of governance. It then rests on discipline: a changelog abandoned for three quarters lies by omission, and nothing enforces it natively. It does not replace the organization-level program: global permissions, compliance, and backups belong to another tier. Finally, the quotas and retention periods cited, verified on August 12, 2026, evolve; check them before any architecture decision.
Key takeaways
- A base's status is decided, not observed: naming an owner and writing one page of conventions is enough to leave shadow IT behind.
- Proven open-source practices — a six-category changelog, semantic versions — transpose as-is to a no-code base.
- One review hour per quarter, eight questions, and every critical base has a chosen trajectory.
The line between the tool that lasts and the shadow IT that blows up does not run between technologies: it runs between the objects someone answers for and the rest. Four artifacts are enough to move a base to the right side. Ownward helps companies perform better through technology — and above all, take back control.
Sources
- Structuring your Airtable bases effectively — Airtable, official documentation, accessed August 12, 2026.
- Six common Airtable design decisions — Airtable, official guide, accessed August 12, 2026.
- Airtable plans and per-plan limits — Airtable, official documentation, verified August 12, 2026.
- Record-level revision history overview — Airtable, official documentation, verified August 12, 2026.
- Establish a Power Platform Center of Excellence — Microsoft Learn, official documentation updated May 14, 2025, accessed August 12, 2026.
- Shadow IT – A Systematic Literature Review — Raković, Sakal, Matković, Marić, Information Technology and Control 49(1), 2020, accessed August 12, 2026.
- Horror Stories: documented spreadsheet incidents — EuSpRIG (European Spreadsheet Risks Interest Group), accessed August 12, 2026.
- Keep a Changelog, specification v1.1.0 — keepachangelog.com, accessed August 12, 2026.
- Semantic Versioning 2.0.0 — semver.org, accessed August 12, 2026.
- Low-code market forecast, press release of December 13, 2022 — Gartner, accessed August 12, 2026.
- Survey of 2,820 business technologists, press release of September 21, 2021 — Gartner, accessed August 12, 2026.
- Study on shadow IT risks, press release of December 20, 2023 — Kaspersky, accessed August 12, 2026.
Ownward internal data, 2026.
Data and pricing verified on August 12, 2026.
Trademarks belong to their respective owners. This article is neither sponsored nor endorsed by the vendors mentioned.
Is this on your desk right now?
Tell us where you stand. We reply with concrete elements — what we would do first, in your business.
Keep reading
All insightsSeptember 1, 2026 · 6 min read
Airtable as scaffolding: build what you plan to take down
In 2025, half of IT projects run over deadline, budget or scope, and nearly one in five is abandoned. Yet every internal tool starts as if it were definitive. Owning the temporary — a no-code base built in days, designed to be taken down — remains the decision nobody dares to claim.
August 18, 2026 · 7 min read
Autonomy-first transformation: the missing category
One model sells recommendations and leaves you to execute alone; the other sells execution and keeps its hands on every change. Neither is paid to make your teams capable. The missing category has one simple criterion: what you can do on your own when the contract ends.