[1] It is widely used in the academic research community: the REDCap Consortium is a collaborative, international network of more than 5900 institutional partners in 145 countries, with more than 2.1 million total end-users employing the software.
[1] Upon request, the informatics core gives the research team a demonstration of REDCap, highlighting the most relevant user interface features.
The researchers then fill out a Microsoft Excel spreadsheet file with key metadata (i.e. field name, data-type, data range, etc.)
The informatics core converts this spreadsheet template into study-specific database tables which are linked to a working web-based EDC forms and applications environment.
The researchers then test this prototype web application by filling out dummy data, and the metadata spreadsheet is revised and refined in an iterative process.