The Client's screening group needed the capability to request sample screening plates to be made from their inventory registered in ActivityBase. They wanted to be able to select plates, track their own and others' orders, and retrieve an aggregate history of what had beed tested. Plate requests were to be sent to Compound Management technicians electronically.
We designed and implemented a light web application that connects to ActivityBase on the back end, lets people request plates, and delivers the requests to Compound Management.
The application does not update anything in ActivityBase but it queries the plate inventory based on user selections. All requests are stored with their status: pending, in progress, submitted. Users can view reports such as:
- How many plates are there in the library collection?
- What are these?
- Which ones have been screened? Against which targets?
- Which ones have not been screened?
On the administration end, the admins are able to update and fill requests, delete requests, add or delete plates, and also aggregate reports such as numbers of plates by requestor, by target, etc. The app is programmed to notify requestors of their request status, when a new request was filed, etc. Users can enter lists of compound IDs and retrieve plate IDs in the event a focused screening set is desired.
