Overview
Brendata Assay is a purpose-built system for managing scientific assay requests, designed to replace a long-standing and increasingly unwieldy Excel spreadsheet.
The client originally relied on a single, heavily modified spreadsheet to capture and track assay data. Over time, it had grown complex, difficult to maintain, and prone to errors. As more users became involved, issues around version control, data validation, and accountability became harder to manage.
We were brought in to turn that spreadsheet into a reliable, web-based application.
The new system captures detailed assay information through a structured interface, applying validation rules at each step to ensure data is complete and consistent. Once submitted, requests are routed to an administrator for review and approval, creating a clear and auditable workflow.
Given the number of users and the need for a smooth experience, the system integrates with Microsoft Active Directory. Users are automatically signed in using their existing Windows credentials, removing the need for separate usernames and passwords and reducing friction from the outset.
Features
The system focuses on making a previously manual process straightforward and dependable:
- A clean, web-based interface for submitting assay requests
- Built-in validation to reduce errors and enforce required data
- Administrator approval workflow, with the option to return requests with comments
- Seamless sign-in via Active Directory
- Automated label generation, matching the format of the legacy system to avoid disruption in downstream processes
- Email reminders to keep requests moving and prevent delays
Deployment
The application is deployed as a virtual machine within the company’s internal infrastructure, ensuring it fits neatly into existing systems and security controls.
It is built using a straightforward, dependable stack: PHP and JavaScript for the front end and application logic, with Microsoft SQL Server handling data storage.