hi would like to create a simple patient tracking system for our small clinic where i can record the time & duration a patient appeared in our establishment. Using a central sheet where it records all the data to be accessible by the admin. There will also be Four (4) forms to be accessible by the three department. Concept design below:
Patient Tracking System with four different access points via forms. Below are the details:
Form Details: What kind of data will each form collect?
Name of patient
Concern Department where the patient will be catered. (multiple department for 1 px may appear)
Time Check-in
Time Check-out
Forms Access:
Reception Access
Laboratory Access
X-ray Access
Doctors Access
For example:
For Reception Access Forms, these are the Fields
Patient Name
Concern Department
Submit
For Laboratory Department Access Forms, these are the Fields
Patient Name (Dropdown List based on Reception Access encoded entry)
Lab Check-in Time (Check button) (link with the date & time)
Lab Check-out Time (Check button) (link with the date & time)
For X-ray Department Access Forms, these are the Fields
Patient Name
X-ray Check-in Time (Check button) (link with the date & time)
X-ray Check-out Time (Check button) (link with the date & time)
For Doctors Department Access Forms, these are the Fields
Patient Name
Doctors Check-in Time (Check button) (link with the date & time)
Doctors Check-out Time (Check button) (link with the date & time)
Data Flow: How should the data from these forms be organized?
All data feed into a central sheet?
Propose Central Sheet Layout:
Date Created | Patient Name | Department Name | Laboratory Check-in | Laboratory Check-out | Xray Check-in | Xray Check-out | Doctors Check-in | Doctors Check-out |
|---|
| | | | | | | | |
| | | | | | | | |
Reception Access: In the Form for Reception Access,
There will be 2 fields
Patient Name (for entry of patient name)
Department Name (for the concerned department, multiple selections of department can be made)
Submit
User rights can enter patient's name in the Patient Name Field & the Department Concern (multiple departments can be selected via dropdown list).
In the Central Sheet,
The name will appear in the Patient Name Column
In the Department Name multiple entry can be made. If the reception will not click the department concern said department cannot view the name of patient on the Patient Name Field on their respective Forms.
Date Created will be automatically filled with the date & time of entry
Laboratory Department Access: In the Form for Laboratory Department Access:
There will be 2 fields
Patient Name (can only view names of patients identified by the reception as concerning the Laboratory Department)
Lab Check-in Time (for recording that the time patient appeared in the Lab for tracking)
Lab Check-out Time (for recording the patient time check-out in the Lab for tracking)
Submit
In the Central Sheet,
The time will appear in the Laboratory Department column. (Time will be dependent on the time the lab check-in time was click.
No access or rights to enter name of patients in the Patient Name Field. Name of patients will be made available in the Patient Name Field once click the Patient Name Field (Name of patient entered by the reception identified with the department will only be visible) . Once selection of names will be made the Lab Check-in Field will appear with the check-box. In the Lab Check-in Field once the check-box is click time will be recorded .
Similar set-up with the X-ray & Doctors Access.
Other conditions:
Entries made by the reception today will not appear the following day in the Patient Name Field of every Forms;
Only the reception can make entries of name of patient.
Only the Admin has the viewing access of the central sheet.
PLEASE Need some assistance. Thank you
