GMS Labs
Client
GMS Laboratories does soil testing for the local agricultural community in Central Illinois. They needed to replace their old DOS based customer database system and synchronize data from their MS Access database and other systems that were not integrated. They had to manually keep these database systems synchronized through repetitive data-entry on a daily basis. Finally they wanted a secure way for customers to make and receive order from their public website.
Solution
By analyzing GMS’s current business systems and processes, our team proposed a complete back office system that would integrate all data and manual systems into one centralized web-based application. We used modern web technologies to rapidly build an intuitive, functional, and powerful business tool that each of their staff and all of their customers would feel comfortable using by using a tool they use every day — a web browser.
Technical Specs
CakePHP, jQuery
GMS Lab - Overview from Jason Rambeck on Vimeo.
Screenshots
Powerful Order workflow and filtering system.
Lab results can be imported and manually entered with validation to ensure accurate results.
Staff can automatically generate pre-filled forms for easy printing.
GMS customers can place orders themselves online and track their orders via email alerts and download their finished reports themselves.
GMS can track financial information for each order and export data to Quickbooks for easy integration into their accounting workflow.