Disclaimer: The information contained on this page forms part of my GPC CPD portfolio and is therefore my personal opinion and in no way reflects the opinion or policy of my employer.
The purpose of this tool was to allow users to set up automated stock level alerts so that an email alert was generated when the stock level of a given drug (E.g. a drug on the “critical medicines list”) falls below a given quantity. Optionally, it allows for a transaction to be entered into an out-of-stock database for further analysis.
The steps involved are:
Create a new record or edit an existing record
Complete or amend all required fields
Validation of new or amended record
Query is run on a Daily basis
Add or Edit an Alert Form
Example Email Output
About Jonathan Tolhurst
Based in London, my interests include photography, kayaking, paddle boarding, electric unicycling, teepees, robotics, programming, databases, informatics and pharmacy.