Forum Discussion

dbryant4891's avatar
dbryant4891
Qrew Trainee
5 years ago

Limit The Number of Tasks Worked

For over a month I've been trying to find a way to limit the number of tasks worked.  My application is setup with a table called Client Request Form.  One of the request types on this form is a Medical Record Request.  We have a specific provider who has asked us to limit the number of medical record requests we send to a physician's associated facility, per day.  I need a way to perhaps put this required number of tasks in queue each day.  So for example, if the end-user logged in this morning, they might see the following:

25 ABC Surgery Center
50 DEF Surgery Group
4  XYZ Surgery Center

Of the above, I need to be able to only send 3 of each, per day.  In addition, I can't exceed sending 12 requests per facility per week.  Any suggestions on how to accomplish this?

Some additional information that may be needed:
Parent Table: Client Request Form
Child Table: Record Request (Client Request Form & Record Request: one-to-many relationship)
Child Table: Physician (Record Request & Physician: one-to-many relationship)
Child Table: Facility (Physician & Facility: one-to-many relationship)

------------------------------
Danaya Bryant
Business Analyst
The van Halem Group
Atlanta GA
------------------------------
No RepliesBe the first to reply