Raise Healthcare · Opera Study

From paper questionnaires and Excel to a connected research workflow

Ficode built a web application for Raise Healthcare that made patient questionnaires easier to complete, captured responses automatically and simplified tracking and reporting.

Digital forms

Replacing paper questionnaires

Automatic capture

Replacing manual Excel entry

Coded records

Random patient identifiers

Easier reporting

Records managed in the application

A simpler way to collect and manage research responses

Raise Healthcare needed a digital alternative to a paper-and-Excel process for Opera Study. Ficode developed a web application that brought questionnaire completion and record capture into one workflow.

The project involved doctors and patients across multiple hospitals or trusts. It supported the collection of observations for research following breast reconstruction, with patient-identifying details represented by random identifiers.

Web application Digital questionnaires Pseudonymised records Healthcare research

A manual process between every questionnaire and its record

Doctors gave patients paper questionnaires, then recorded their answers in Excel. The process required manual transfer of information and made records harder to track and report on across the people involved.

Before Paper & Excel

Paper forms

Patients complete questionnaires

Manual entry

Doctors transcribe answers

Excel records

Records managed in spreadsheets

With Opera Study Digital workflow

Web questionnaires

Patients submit responses online

Automatic capture

Responses saved in the application

Track & report

Records easier to follow and review
Ficode digitised the questionnaire and record-capture process, replacing the previous paper-and-Excel workflow.

Digitise the form. Capture the response. Simplify the follow-up.

Ficode developed a web application to replace the previous paper-and-Excel workflow. Patients could fill in questionnaires digitally, and their responses were saved automatically in the application.

01 / COMPLETE

Web-based questionnaires

A digital route for patients to provide their responses.

02 / CAPTURE

Automatic saving

Responses captured directly in the application without the previous transfer into Excel.

03 / TRACK

Manage records

An easier way to follow records within the application.

04 / REPORT

Review information

Reporting supported by digitally captured responses.

Patient records represented by random identifiers

Random numbers replaced patient-identifying details in the research workflow. An internal mapping linked those numbers to the corresponding patient information.

Patient details

Identity information

Internal mapping

Links the identifier to the patient

Random identifier

Used in place of identifying details
Questionnaire records represented by a code The internal mapping preserves the link to the patient.

This is pseudonymisation: records remain linkable to patients through the internal mapping. It is not the same as permanently anonymising the information

Less manual handling. A more manageable process.

Ficode confirmed qualitative improvements in how questionnaires were completed and records managed.

Easier for patients

Patients complete questionnaires digitally through the web application.

Automatic record capture

Responses are saved in the application without the previous transcription into Excel.

Simpler reporting

Information held in the application is easier to review and report on.

Easier tracking

Teams can follow records within the application rather than relying on paper forms and spreadsheets.

Supporting research, not claiming clinical results. Ficode supplied and developed the application. Research findings were not shared with Ficode, so this case study makes no claims about treatment effectiveness or improved clinical outcomes.

A web application hosted on Amazon EC2

The delivered solution was web-only, with AWS used to host the application on an EC2 instance.

Participation involved multiple hospitals or trusts, doctors and patients. Confidential records and participation figures are not disclosed.

Ready to move beyond paper forms and spreadsheets?

Talk to Ficode about a purpose-built web application for collecting information, managing records and supporting your team’s workflow.

Get in Touch