Mark L Posted February 24, 2005 Share Posted February 24, 2005 (edited) This forum has so many brilliant minds (I say this in all earnestness) - I'm looking for ideas on how to best handle the following: Part of the application I'm developing requires users to enter results for dozens of medical tests from paper print offs. Regionally, each lab provides these results in a different order ' so I've decided that using a portal is the way to offer the user control over which sort of the entry records. I have other postings on that topic ' and think I've overcome the sort issues. ALSO users need to (on rare occasions) add their own tests to the list (in my example, they may add two new tests to the existing 53) - so hard coding the tests isn't really an option for that reason too. Here's my next challenge: I'm not sure how I'm going to 'automatically' populate the portal with the dozens of 'blank' records for data entry. I put 'blank' in quotes ' because they are not really blank ' quite the opposite ' they will have all the information except the actual test result value that needs to be entered. Here's an example of a few 'blank' records: Sort Order Test Name *Test Result* Test Units ------------ ------------- --------------- ------------- 1 XYZ Test _____ mg/dl 2 QQ3 Test _____ k/cumm 3 ABC Test ______ ratio (50 records later:) 53 SQP Test _______ mg/dl Once the user fills in the test results (and some results may be left blank) ' I'll need to write out the records with the patient's ID & and the date. So I'm looking for suggestions on how to have a fixed number - 53 (using the example above) 'pre-populate' the portal. Secondarily ' if anyone has suggestions on how to best write the records out ' including the situation where the user aborts the input effort and the portal records shouldn't be saved/committed ' I'd truly appreciate it. My gut seems to say have a script that picks up the PatientID and Lab Date (business rule is there can only be one set of tests related to one Lab Date - so it can be a key) Copies the "blank" records from a database where the 53 "blank" records are stored, pend the Patient ID and Lab Date to them, then open up the Test Entry Layout, which has the portal to the freshly written out records. When test entry is complete, save the records. One worry is how would someone be able to come back and edit records - and another is "false commitments" (someone entered the data for the wrong patient - needs to delete the old and re-write under a different patient.) Any insight people have into this would be greatly appreciated. Sincerely, Mark Edited January 13, 2007 by Guest clean up Link to comment Share on other sites More sharing options...
This topic is 5910 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now