| Ethix Systems caught on quickly to our lab terminology and was able to provide us with new formats as well as correct errors we have been having with existing formats. They were quite a find! |
Manager of Customer Service
Vision: Founded in 1984, Microseeps is a full service laboratory and a recognizable leader in the development of specialized analytical methods to support monitored natural attenuation and other in situ remediation techniques. They utilize a large application known as a LIMS system to manage this process, including the transmission of electronic data files (or EDDs) to their clients.
Problem: Microseeps receives frequent requests from clients seeking their EDDs in a different data format that works with their own databases. These requests must be processed in a stored procedure in MS-SQL. They had a part-time person only able to work 4-5 hours a week and the requests were not being completed in a timely fashion.
Solution: Ethix Systems currently processes all of Microseeps' requests for new and modified EDDs and aid in troubleshooting any EDD issues. Ethix Systems has also modified the LIMS system moderately for improved efficiency. In addition, Ethix Systems spends only 25% of the originally projected time completing these requests, saving Microseeps additional cost in having the EDDs completed.
Check out our online Dynamic Dropdown demo at
http://newsletter.ethixsystems.com
Many times when working with a client on a web form, a decision has to be made between a dropdown field and a plain text input. Dropdown fields work great to limit user input, but then there is no way to add options to the dropdown. Plain text inputs allow the addition of new options, but there can be spelling mistakes that hinder data integrity.
As a solution to this problem, we have developed a combination of the two using an AJAX routine. As the user types, the options already in the database show up in a dropdown menu. If they want to add a new option, they can just keep typing. This kind of field makes data entry much easier, especially for name fields, since misspellings can occur very easily.
| Normal Text Field | ||
|---|---|---|
 | This user is about to add "Mircosoft" to the database by accident. This will compromise data integrity if not caught. | |
| Dynamic Dropdown Field | ||
 | The dynamic dropdown allows you to add fields AND see if your choice is in the database already. A perfect combination of usability and data integrity. | |
This feature can be added to any PHP enabled website with ease.
