|Year : 2020 | Volume
| Issue : 10 | Page : 5295-5302
Prescription digitization, online preservation, and retrieval on a smartphone
Tanmoy Chattopadhyay1, Himel Mondal2, Shaikat Mondal3, Rajib Dutta4, Koushik Saha5, Debasish Das6
1 Department of Medicine, Ramakrishna Mission Seva Pratishthan, Vivekananda Institute of Medical Sciences, Kolkata, West Bengal, India
2 Department of Physiology, Bhima Bhoi Medical College and Hospital, Balangir, Odisha, India
3 Department of Physiology, Raiganj Government Medical College and Hospital, Raiganj, West Bengal, India
4 Sick Newborn Care Unit, Basirhat District Hospital, Basirhat, West Bengal, India
5 Department of Anatomy, Rampurhat Government Medical College, Rampurhat, West Bengal, India
6 Department of Physiology, Fakir Mohan Medical College, Balasore, Odisha, India
|Date of Submission||26-Apr-2020|
|Date of Decision||10-Jun-2020|
|Date of Acceptance||24-Jun-2020|
|Date of Web Publication||30-Oct-2020|
Dr. Himel Mondal
Department of Physiology, Bhima Bhoi Medical College and Hospital, Balangir - 767 002, Odisha
Source of Support: None, Conflict of Interest: None
Background: Medical records are important documents that should be stored for at least 3 years after the commencement of the treatment of an adult patient in India. In a health care facility, patients' data is saved in an online or offline retrieval system. However, in the case of the primary care physician, the data is not commonly kept in an easily retrievable system. Aim: To test the feasibility of using a set of free web-based services in digitization, preservation, and retrieval of prescription on a smartphone by primary care physicians. Methods: This study was conducted with 12 primary care physicians. They were provided hands-on guides on creating an online form for uploading a prescription and using an application for retrieval of the prescription on a smartphone. Their feedback on the training material was collected by a telephonic survey, which had a 10-point Likert-type response option. Then, an in-depth interview was conducted to ascertain their perception on the tutorial and the process of digitization and retrieval system. Results: All of the participants were able to create an online form on their smartphone. They uploaded their prescription and associated data and were able to retrieve it. The physicians opined positively on the “cost of the system,” “portability” on a smartphone and ease of the “tutorial”. They opined negatively on the “limited storage,” chances of “loss of data,” and “time constraints” for entry of the patients' data. Conclusion: Free web-based and smartphone applications can be used by a primary care physician for personal storage and retrieval of prescriptions. The simple tutorial presented in this article would help many primary care physicians in resource-limited settings.
Keywords: Cloud computing, electronic health record, medical records, private sector, physician, smartphone, telemedicine
|How to cite this article:|
Chattopadhyay T, Mondal H, Mondal S, Dutta R, Saha K, Das D. Prescription digitization, online preservation, and retrieval on a smartphone. J Family Med Prim Care 2020;9:5295-302
|How to cite this URL:|
Chattopadhyay T, Mondal H, Mondal S, Dutta R, Saha K, Das D. Prescription digitization, online preservation, and retrieval on a smartphone. J Family Med Prim Care [serial online] 2020 [cited 2021 Jul 30];9:5295-302. Available from: https://www.jfmpc.com/text.asp?2020/9/10/5295/299389
| Introduction|| |
Medical records (e.g., prescription, diagnostic test reports, and medical certificates) are important documents for the patient, health care facility, and doctors. In a developing country like India, most of the records are kept as a paper document. There are several advantages (e.g., no need for personal computer or internet, no threat of cyber-attack) and disadvantages (e.g., decay in the paper, damage due to natural disaster, huge space requirement) of keeping the paper document.,
For easy retrieval and convenience of handling, private sector and government-run hospitals are gradually adopting electronic health records (EHR). However, its implementation faces difficulty due to factors like low resource, high patient volume, less manpower, etc.
Keeping medical records requires 3 major components – hardware (i.e., computers), software (i.e., electronic-health record keeping application for computers), and manpower (e.g., doctors' assistants). A primary care physician may face difficulty in acquiring and maintaining those costly and space-occupying system of EHR.,
However, for a medico-legal point of view in the Indian scenario, the medical record should be kept for at least 3 years from the initiation of treatment of an adult subject.
“Google forms” is a web-based application, which can be used to create a form for data collection. It is a free service and it can be utilized by a user to keep the data on the cloud. To the best of our knowledge, its potential in digitization and retrieval of prescription has not been explored in any previous study.
With this background, the aim of this study was 1) to train primary care physicians about creating a form, upload prescriptions, and retrieval of the data on a smartphone 2) to test the practicality of the training material (i.e., tutorial) with the help of a survey, and 3) to ascertain overall perception regarding the training material, the digitization, and the retrieval system by an in-depth interview.
| Materials and Methods|| |
A common prescription is shown in [Figure 1]. Keeping only the image of the prescription with an identification number may not be sufficient for easy retrieval. Hence, we aimed to keep searchable data (typed) such as name, age, sex, date, type of visit, and provisional diagnosis on the cloud storage. In this article, all the technical guideline is discussed for a smartphone running on the Android operating system.
|Figure 1: A typical prescription (red arrows show essential parts for data entry)|
Click here to view
- A smartphone equipped with a camera
- Internet connection
- A Google account
- Software application – Google Chrome, Google Drive, Google Sheets
A dedicated smartphone home screen can be created with the application on the smartphone for easy navigation as shown in [Figure 2].
|Figure 2: A smartphone home screen showing essential components for storing and retrieving prescription|
Click here to view
Creating a form on Google forms
The method of Google form creation on a personal computer for a medical survey is available elsewhere. In this article, Google form creation is shown for a smartphone (connected to the internet). [Figure 3] shows the screenshots of the smartphone screen and the brief procedure is as follows:
|Figure 3: Process of creating a Google form (a) open the website (b) write the form title (c) write question on “Untitled Question” and for adding more, click on “+” icon (d) add “Date of visit” question (e) add “Type of visit” question (f) add “Name of the patient” question (g) add “Sex” question (h) add “provisional diagnosis” question (i) add “Prescription front” and keep “File upload” as response option (j) add “Related document” question (k) click on the share icon (l) generate web link|
Click here to view
- Open the Google Chrome and open the website http://docs.google.com/forms [Figure 3]a
- Type suitable title (e.g., My Digital Prescription) and description of the form [Figure 3]b
- Type the first question in “Untitled Question” and to add a new question, use the “+” sign [Figure 3]c
- The first question is typed as “Date of visit”. Google provides automatic response options according to the nature of the question. However, if the response option is not as desired, use the dropdown menu to select “Date” [Figure 3]d
- “Type of visit” is typed as the next question and response option is selected as “Multiple choice” [Figure 3]e
- The next question is “Name of the patient” and response option is “Short answer” [Figure 3]f
- The next question is to know the “Sex” of the patient and response option is “Multiple choice” [Figure 3]g
- To enter the “Provisional diagnosis,” the response option is selected as “Short answer” [Figure 3]h
- For uploading the prescription image, the question “Prescription front” is typed and the response option is selected as “File upload” and only “PDF” and “Image” are allowed to be uploaded. Similarly, the prescription back question may also be added [Figure 3]i
- Diagnostic reports, consent form, or any clinical images for research purposes can be saved under any question (e.g., Related document) and the response option is selected as “File upload.” [Figure 3]j
- After entering all the desired questions, click on the share icon to get options for sharing. [Figure 3]k
- Click on the link button to get the URL (you may shorten the URL too) and copy it. [Figure 3]l
Open the link on the Google Chrome browser and click on the “more vertical” icon (i.e., three vertical identical dots) and click on the “Add to Home screen” to take the link of the form to your smartphone home screen, which is basically a shortcut of the URL. Its appearance on the smartphone screen is shown in [Figure 2] (Form Shortcut). Now the smartphone is ready for capturing prescription and other data.
Data entry process
In [Figure 4], the processes of typing data and uploading a prescription are shown and the steps are following:
|Figure 4: Process of uploading a prescription (a) open the form on the browser (b) form will be shown with the Google account you are logged in (c) write name of the patient (d) write provisional diagnosis (e) click on “ADD FILE” under “Prescription front” (f) click on “Select files from your device” (g) choose “Camera” and capture image (h) click on “Upload” (i) progress will be shown (j) prescription file uploaded (k) after completion of data entry, click on “SUBMIT” (l) confirm message will be shown|
Click here to view
- Click on the form shortcut on the home screen [Figure 2] of the smartphone and the form will be opened on the default internet browser (e.g., Google Chrome) [Figure 4]a
- You need to be logged in for entering data on the form and your email address will be shown on the screen. Enter the date of the visit as desired [Figure 4]b.
- Type the name, age, and sex (demographics) of the patient [Figure 4]c
- Type the provisional diagnosis or any other comments about the consultation [Figure 4]d
- Click on the “ADD FILE” for uploading a prescription [Figure 4]e
- Click on the “Select files from your device” [Figure 4]f
- Select “Camera [Figure 4]g and it will open the camera application of the smartphone. Capture the image of the prescription keeping it flat on a surface with adequate light.
- Click on the “Upload” for uploading the prescription [Figure 4]h
- Allow time for the upload (depends on the internet speed) [Figure 4]i
- A successful upload is indicated by the image file icon below the question [Figure 4]j
- After uploading “Prescription back” or “Related documents” (in the figure no files uploaded under these questions), click on the “Submit” button [Figure 4]k
- “Your response has been recorded” is the success message [Figure 4]l
There is an option for “Submit another response.” Physicians can keep their phone on this screen for the next patient. If this option is not desired, then open the form shortcut from the home screen [Figure 2] to start filling the form afresh.
For smooth retrieval, once we need to create the spreadsheet from the form and next time onwards entered data will be automatically updated on the spreadsheet. [Figure 5] shows the screenshots and the process is:
|Figure 5: Process of retrieving data (a) after opening form, click on the edit icon (b) click on “RESPONSES” (c) click on the green spreadsheet icon (d) click on “CREATE” to create a new spreadsheet (e) spreadsheet is shown on the browser (f) open “Google Sheets” application and click on sheet icon (g) sheet is shown in the application (h) click on the link of the prescription to view it|
Click here to view
- Open the form on the browser from the shortcut [Figure 2] and click on the edit button [Figure 5]a
- Click on the “RESPONSES” [Figure 5]b
- The page will show the responses captured on the form. Click on the spreadsheet icon (green icon) [Figure 5]c
- Prompt to “Create a new spreadsheet” will appear and click on “CREATE” [Figure 5]d
- A spreadsheet with responses will appear on the browser [Figure 5]e. You may view responses from the browser. However, we suggest exiting the browser to do the next step.
- Open the “Google Sheets” application from the home screen [Figure 2] and the created sheet will appear [Figure 5]f
- Entered data will be shown on a spreadsheet on the application [Figure 5]g
- Click on the corresponding prescription file link and it will open the prescription on the Google Drive [Figure 5]h
Training of the physician
Twelve primary care physicians, after taking verbal consent, were recruited as a convenience sample. We distributed the tutorial via email for training on the creation of Google form on the smartphone, uploading a prescription, and retrieving the prescription from the cloud via Google Drive. We declare that we have conducted this study with full accordance with the WMA declaration of the Helsinki.
Survey and interview
After 30 days, a telephonic survey was conducted to know the experience of the doctor in creating forms and its usages. Verbal consent was taken for recording the telephone call. The participants were also informed that after transcription, the call would be deleted. Predesigned questions were asked with response options on a 10-point Likert-type scale where 0 indicates “extremely difficult” and 10 indicates “very easy.”
After this, in the same telephonic session, an in-depth interview was conducted to know the perception of the participant about this method of prescription digitization and retrieval.
Continuous variables were expressed in mean and standard deviation and mean of male and female was compared by unpaired t-test. Categorical data were expressed in number and percentage and tested statistically by the Chi-square test and Binomial test. For all the tests a P < 0.05 was considered statistically significant. Statistical analysis was carried out in IBM® SPSS® Statistics Version 20 software package (IBM Corporation, USA) and Microsoft Excel® 2010 (Microsoft, USA).
| Results|| |
A total of 12 doctors participated in this study. All of them successfully created the form for their personal use. Characteristics of the participants are shown in [Table 1].
The score of response received on experience on creation, uploading, and retrieving prescription is shown in [Table 2]. All of them found it to be an easy method of prescription digitization and retrieval.
For average measures, the intraclass correlation coefficient was 0.915 (95% confidence interval 0.820–0.971, P < 0.0001). This indicates “excellent” inter-rater agreement on the usefulness of the tutorial.
Result of the in-depth interview was categorized thematically and presented here. The participants' identity is expressed serially in age, sex, practicing experience (e.g., 30M2Y indicates a 30-years-old male practicing for 2 years). Additional notes were added after a colon.
Google form is free for users. All participants liked the system as it is a free service. Ease of uploading data with some clicks on the smartphone also partially eliminates the requirement of a data entry operator.
“…the icing on the cake is that it is totally free service” (28F1Y)
“It could have been saving my money and space if I were aware of it.” (35M3Y: One who keeps carbon copies of the prescriptions)
All the components – creating from, data entry, and retrieval can be done on a smartphone. A total of 9 participants opined its advantage of being a smartphone-based system. This eliminates carrying a personal computer to all the chambers. Rest 3 participants think that a laptop computer with a camera may also be tried if data is entered by physicians' assistants.
“It's great! We can just do it on our smartphone.”(31M2Y).
The lucid presentation of the tutorial helped the participant, which was praised by 6 participants. The rest 6 participants, though agreed that the presentation was lucid but opined that a video tutorial could help them more. However, one participant requested to add a segment on how to remove a question.
“…and the tutorial is really easy to understand. I created the form in 5 min. Everybody else would be benefited by the tutorial.” (29M1Y)
Google Drive allows a free user to store a maximum of 15 GB of contents. Three participants pointed out this issue. Six participants would digitize only important prescriptions to save space. Rest 3 had their personal tricks on how to avoid the limits. However, we are not sharing it here. A user can buy extra space from Google.
“…and the 15 GB may become very less space because smartphone images are now high-quality, and it uses higher space per image. It is also difficult to upload a large-sized image with a slow-speed internet.” (33M4Y)
Loss of data
Anyone having access to the mobile may view the medical records. The medical records are confidential data, which should have limited access to doctors, patients, and the health care facility except for some health care needs or medico-legal cases. Three participants were worried about this factor. The rest of the participants were opined that keeping data on smartphones have a similar threat as keeping data on personal computers.
“What if I lose the mobile? All the data would be in the hands of the thief.” (32F4Y)
On average, participants take 1 min 30 s (average 92.5 ± 23.79 s, range 60–120 s, n = 12) for uploading a prescription. Two participants thought the time to be an important inhibiting factor. However, the rest of the participants were ready to invest the time.
“It is really a hectic job to keep all the prescriptions in digital format. However, it is a good practice to avoid any legal complication.” (44M14Y)
| Discussion|| |
A total of 12 primary care physicians used the tutorial to successfully create Google form, upload the prescription, and retrieve those from cloud storage. The tutorial was designed purposefully for a smartphone to help the busy physician who can easily do it even in their spare time. One participant created the form in just 5 min.
The result of this study shows that the participant had no technical difficulty in the generation of the form on their smartphone. Hence, the tutorial, presented in this article can be used by the physicians who would like to keep their prescription digitized. Primary care physicians frequently need to issue certificates of death, illness, or fitness. Those who are not ready to digitize all of their prescriptions can digitize these important certificates for any medico-legal cases. However, it is wise to keep all the records for 3 years. Patients, their representatives, or legal authorities may demand the document in this period and physicians need to submit it within 72 h.
Primary care physicians in India are not commonly participating in research. However, they have the potential to participate in research activity. Preservation of patient particulars, treatment details, and images of any lesion may contribute to research output with collaboration with other primary care physicians.
Informed consent (verbal) for treatment by a primary care physician is rarely documented. However, as telemedicine is being started in India due to the COVID-19 pandemic, saving the consent may be necessary for all the telemedicine consultations for avoiding legal complications.
Although EHR was introduced long back, its implication is still not achieved due to several factors, major being cost, time, manpower, and the technology being a complicated one. Even digitization of data in EHR may take more time than the consultation time. Lack of universal EHR software further limits the use of the national-level data. The method we described in this article is for resource-limited settings for those who cannot afford EHR.
Portability is the issue, which was favored by the majority of the participants. However, many issues rose by the participants on the in-depth interview, which may be the inhibitory factors for the physicians to adopt this method for prescription preservation. Storage limitation was one of the major concerns in free accounts. To overcome this, a user can upgrade the storage capacity by opting for premium packages. Further, users can limit the data per patient by decreasing the quality of the prescription images (e.g., setting quality of the image as “low” of an image of resolution 3120 × 4160 pixel takes 855 KB whereas same resolution “high” quality image takes 4.54 MB). According to EHR standards for India, the image should be of minimum of 1024 × 768 pixels at 300 dpi.
Security of the data is an important issue, which should be taken care of by the physicians. A smartphone is vulnerable to be stolen. That is really a threat to data security. However, this can be prevented by using a strong password for the smartphone and setting the password or fingerprint compulsory for opening any application. Losing a phone does not mean loss of data. As soon as you get a new smartphone, the whole stored data can be loaded on the new device as it is stored on the Google drive. It is also recommended not to use the Google account (in which prescriptions are kept) in public computers or any computer without proper security (i.e., without internet security application). Using an antivirus application on the smartphone is a good choice.
Although, there are several disadvantages of the paper document, major being the difficulty in retrieval from remote location or retrieval from a huge bunch of paper, its robustness in data storage cannot be questioned. In contrast, despite the chances of device malfunction or loss, cloud storage is relatively safe, devoid of disadvantages of the paper document, and easily retrievable.
In the current COVID-19 pandemic, many primary care physicians have started teleconsultations despite several limitations., They can use these free services for storing patients' data for any future legal needs.
| Conclusion|| |
Primary care physicians can use Google forms for saving patients' particulars and upload prescription images. Google Sheets, another free application, can be used for easy retrieval of entered data. The smartphone-based tutorial available in this article can be used to learn the creation, upload, and retrieval of the data. This free, portable, and easily manageable system can help many of the primary care physicians. However, careful and secure usage should be ensured by the physicians to prevent any misuse of the medical records.
Financial support and sponsorship
Conflicts of interest
There are no conflicts of interest.
| References|| |
Thomas J. Medical records and issues in negligence. Indian J Urol2009;25:384-88.
] [Full text]
Singh S, Sinha US, Sharma NK. Preservation of medical records-An essential part of health care delivery. Indian Intern J Forensic Med Toxicol 2005;3: 1-7
World Health Organization. Regional Office for the Western Pacific. Medical records manual: A guide for developing countries. Manila: WHO Regional Office for the Western Pacific. Available from: http://www.who.int/iris/handle/10665/208125
[Last accessed on 03 Apr 2020].
Srivastava SK. Adoption of Electronic Health Records: A Roadmap for India. Healthc Inform Res 2016;22:261-9.
Evans RS. Electronic health records: Then, now, and in the future. Yearb Med Inform2016;Suppl 1(Suppl 1):S48-61.
McGregor DM. Evaluation of the steps for implementation of electronic health records for a small chiropractic practice in Northern Michigan. J Chiropr Humanit 2009;16:54-6.
Lorenzi NM, Kouroubali A, Detmer DE, Bloomrosen M. How to successfully select and implement electronic health records (EHR) in small ambulatory practice settings. BMC Med Inform Decis Mak 2009;9:15.
Bali A, Bali D, Iyer N, Iyer M. Management of medical records: facts and figures for surgeons. J Maxillofac Oral Surg 2011;10:199-202.
Mondal H, Mondal S, Ghosal T, Mondal S. Using Google forms for medical survey: A technical note. Int J Clin Exp Physiol 2018;5:216-8.
Rayhan RU, Zheng Y, Uddin E, Timbol C, Adewuyi O, Baraniuk JN. Administer and collect medical questionnaires with Google documents: a simple, safe, and free system. Appl Med Inform 2013;33:12-21.
Mathiharan K. Medical records. Indian J Med Ethics 2004;1:59.
Kumar R. Frequently asked questions about family medicine in India. J Family Med Prim Care 2016;5:3-6.
] [Full text]
Koskela TH. Building a primary care research network-lessons to learn. Scand J Prim Health Care 2017;35:229-30.
Hall DE, Prochazka AV, Fink AS. Informed consent for clinical treatment. CMAJ 2012;184:533-40.
Kruse CS, Kothman K, Anerobi K, Abanaka L. Adoption factors of the electronic health record: A systematic review. JMIR Med Inform 2016;4:e19.
Baumann LA, Baker J, Elshaug AG. The impact of electronic health record systems on clinical documentation times: A systematic review. Health Policy 2018;122:827-36.
Kruse CS, Stein A, Thomas H, Kaur H. The use of electronic health records to support population health: A systematic review of the literature. J Med Syst 2018;42:214.
Young RA, Burge SK, Kumar KA, Wilson JM, Ortiz DF. A time-motion study of primary care physicians' work in the electronic health record era. Fam Med 2018;50:91-9.
Persaud N. A national electronic health record for primary care. CMAJ 2019;191:E28-9.
Menachemi N, Collum TH. Benefits and drawbacks of electronic health record systems. Risk Manag Healthc Policy 2011;4:47-55.
Das AV, Rani PK, Vaddavalli PK. Tele-consultations and electronic medical records driven remote patient care: Responding to the COVID-19 lockdown in India. Indian J Ophthalmol 2020;68:1007-12.
] [Full text]
Mishra V. Factors affecting the adoption of telemedicine during COVID-19. Indian J Public Health 2020;64(Supplement):S234-6.
[Figure 1], [Figure 2], [Figure 3], [Figure 4], [Figure 5]
[Table 1], [Table 2]