Build your own data capture, or buy a compliant EDC
A spreadsheet or a form builder can capture data. What it cannot do on its own is make that data defensible: a field-level audit trail, e-signatures tied to what was actually signed, role-based access, and edit checks that catch a bad value automatically. Here is what "build" really requires, and where buying wins even for a technical founder.
- What "build" really requires
- Where teams underestimate the work
- A free way to test buying first
Free sandbox · No credit card · 21 CFR Part 11 aligned
4
controls a defensible system needs beyond a plain form
0
of them come built into Airtable or Google Forms
1
platform if you buy, instead of stitching several tools
Free
to test the buy path before committing either way
What "build" actually means
A spreadsheet can capture data. It cannot make it defensible.
Teams that reach for Airtable or Google Forms usually plan to capture the data first and worry about compliance later. The problem is that the controls a monitor or inspector will ask about are exactly the ones a generic form tool was never designed to have.
- A timestamped, attributable audit trail on every field, not just a version history
- Electronic signatures tied to the exact content signed, with countersignature
- Role-based access with PII segregation, not a shared spreadsheet link
- Edit checks that raise a query automatically, not a manual review pass
Weight changed 68.0 to 68.5 kg
Site coordinator · Reason: Transcription error
Query Q-0014 answered on Weight
Site coordinator · Reason: Source checked
Vital signs form locked
Data manager · Reason: Visit cleaned
Side by side
What each path actually costs
When building still makes sense
Build can be the right call for a narrow set of studies
This is not a blanket argument against building. A very early internal pilot, with no participant PII and no intent to submit the data anywhere regulated, may not need a compliant EDC yet. The moment a study collects identifiable participant data, needs an audit trail for a sponsor, or is heading toward a regulatory submission, the calculation changes.
- Fine to build: an internal, non-regulated feasibility check with no participant PII
- Reconsider building: any study heading toward an IRB, a sponsor or a submission
- Free sandbox lets you test the buy path without committing before you decide
Before you decide
What to check before you commit to either path
Cost
Free sandbox to build and test your real study; you pay only once you go live.
Compliance
21 CFR Part 11-aligned controls and a field-level audit trail come built in.
Setup time
Configuring an existing system is typically faster than building the same controls from scratch.
Migration
Bring an existing spreadsheet-based study across once you decide to switch.
Support
Email support, typically under 24 hours, versus owning every bug yourself.
Test the buy path, free
Build your real study in the sandbox before you decide either way. No credit card.
Is Airtable or Google Forms ever fine for a clinical study?
For a very early, non-regulated internal pilot with no participant PII, it can be. Once a study involves identifiable participant data, a sponsor, or a path toward a regulatory submission, those tools lack the audit trail, e-signatures and access controls that will be expected.
What is the biggest thing teams underestimate about building their own?
The audit trail and e-signature workflow. A version history is not the same as a timestamped, attributable, tamper-evident audit trail, and most form tools have no compliant e-signature flow at all.
How long does it take to switch from a spreadsheet to an EDC?
It depends on the study's size, but configuring forms in an existing system is typically faster than building the same controls from a blank page. The free sandbox lets you test this on your own protocol before committing.
Does buying always cost more upfront than building?
Not necessarily. Capture's free sandbox has no setup fee and no credit card required to build and test a full study; you only pay once you go live with real participants.
Can we migrate an existing spreadsheet-based study into Capture?
Yes. You can bring an existing study across once you decide to switch, rather than starting data collection over from zero.
What does it cost to try?
Nothing to start. The free sandbox has no credit card and no time limit.
Keep exploring
Related pages
How to run a clinical trial without a CRO
Running the data capture side yourself, the right way.
21 CFR Part 11 compliance checklist
The specific controls a compliant system needs.
Audit trail software for clinical trials
A closer look at what a real audit trail requires.
Clinical trial software free trial
Test the buy path yourself, free.
Test the buy path, free
Build your real study in the sandbox before you decide either way. No credit card.