juggernautsei wrote on Monday, May 04, 2015:
I was wondering has anyone developed a feature that will randomly select patients for drug screening?
I have an anesthesiologist that would like this feature. The criteria is that each day 8 patients at random has to be selected for drug screening test. The patient can only be tested three times a year at most.
I would like to hear some suggestions on how to approach building this feature.
fsgl wrote on Monday, May 04, 2015:
Start with Reports/Clients/Clinical.
juggernautsei wrote on Monday, May 04, 2015:
I don’t understand why start there. This report is to find a specific drug patient relationship.
He wants the program to pick 8 people from the people on the schedule at random. Please give me a little more insight as to the suggestion.
fsgl wrote on Monday, May 04, 2015:
That report will give you a list of patients seen over a period of time.
Then it your job to write a script to randomly choose 8 at a time & exclude selected name for the next random drawing.
A possible solution is to run a query, select 8 & then run a “minus” query as explained here.