1. Introduction

The SMRP Automator is a Chrome Extension designed to streamline data entry for Dietetic modules within the Ministry of Health's SMRP Portal (MyHDW). It integrates directly with Google Sheets to eliminate manual double-entry, automates patient registration, and ensures data accuracy.

2. Installation Guide

You can install the SMRP Automator directly from the Chrome Web Store.

Step 1: Download from Store

1. Visit the Chrome Web Store Link.
2. Click the blue "Add to Chrome" button.
3. Confirm by clicking "Add extension" in the popup.

Step 2: Troubleshooting "Access Denied" Errors

Why is this happening?
Your browser is currently signed in with your official Ministry of Health account (@moh.gov.my). The system administrator for MOH has blocked access to the Chrome Web Store for security reasons.

The Solution:
You must switch to your personal Gmail account to perform the download.

1. Click your Profile Icon at the top right of the Chrome browser.
2. Select your personal account.
3. Once switched to the personal profile, reload the Web Store link.
4. You will now be able to click "Add to Chrome".

3. Google Sheet Configuration

The automation is tailored according to the E-Pelaporan Google Sheet Layout. Based on the Sheet Name selected, the extension will read data from the following specific columns:

A. Inpatient Data (Sheet: P.DALAM)

• The extension reads data from Columns: C, E, G, H, J, K, L, M, O, Q

B. Outpatient Data (Sheet: P.LUAR)

• The extension reads data from Columns: B, E, F, G, H, I, K, N

C. Group Counseling Data (Sheet: MNT BERKUMPULAN)

• The extension reads data from Columns: B, D, E, F, H

4. Initial Setup

1. Open Settings: Click the Gear Icon inside the extension.
   

   Figure 4.0: Opening Settings
2. Link Spreadsheet: Paste your Spreadsheet ID from your Google Sheet URL (the string between /d/ and /edit) and select the Sheet Name.
   

   Figure 4.1: Finding the Google Sheet ID
3. Safety & Submission Toggles:
   • Auto-Submit Data: (Checked by default) The extension will automatically click the final save/submit buttons for you. Uncheck this if you prefer the automation to pause right before submission, allowing you to manually review the filled form.
   • Strict IC Match Guard: (Checked by default) A critical safety feature that extracts the patient's IC from your Google Sheet and compares it to the IC displayed on the SMRP Portal. If they do not match, the automator instantly aborts to prevent entering data into the wrong patient's file.
   

   Figure 4.2: Configuring Safety Toggles
4. AHP Number (Allied Health Practitioner):

   Enter your own IC Number (without dashes) or AHP Number into the "AHP Number" field in the settings menu.

   This is the unique identifier (IC / AHP Number) for the Dietitian performing the entry. It is NOT the patient's IC.
   

   Figure 4.3: Therapist Name & AHP
5. RN Configuration (Registration Number):

   When you click "Add Clinical Support" to register a patient, the system generates a unique RN string. The extension automates the custom suffix part of this number.

   Format Example: HTAR110126SSDT10001

   • HTAR: Facility Location (Auto-generated by SMRP).
   • 110126: Date (Auto-generated by SMRP).
   • SS: System Code (Fixed).
   • DT10: DT Prefix (Configured in Extension Settings).
   • 001: Next RN Seq (Configured in Extension Settings).

   To Configure:

   • DT Prefix: Enter your department code (e.g., DT01, DT10, DT30).
   • Next RN Seq: Enter the starting number for the day (e.g., 001). This number auto-increments after every successful registration.
   
   

   Figure 4.4: Configuring Registration Prefix and Sequence
6. Authorize (CRITICAL STEP): Click Test Connection. A Google sign-in window will appear. You MUST log in using your official Workspace Email (@moh.gov.my). Do NOT use the personal email that you used to download the extension.
   
   
   

   Figure 4.5: Successful Connection using Workspace Email

Activity Log (History): Click the clock icon (left of the settings gear) at any time to view a log of your most recently submitted data entries.

5. Workflows

Before You Begin: Preparation

1. Understanding Row Numbers (Row Num):

The 'Row Num' field in the extension tells the automator exactly which patient's data to grab from your Google Sheet. Look at your spreadsheet, find the specific row number on the far left edge for the patient you are working on (e.g., Row 14), and type that exact number into the extension.

2. Portal Navigation:

1. Log in to the SMRP portal as usual.
2. You must land on the Patient Search Page. The extension will start by auto search for patient IC number if you trigger it from this specific page.
   

   Step 3: The SMRP Patient Summary Page

Workflow A: Outpatient & Group Counseling Registration

Use this workflow for new outpatient or Group Counseling cases that need a new Registration Number (RN).

1. Ensure you are on the Patient Summary Page.
   

   Step 1: Ensure you are on the Summary Page
2. Click the gear icon, then change the sheet name to P.LUAR or MNT BERKUMPULAN, and set the Row Num to the patient's row in your Google Sheet.
   

   Step 2: Change Sheet Name and Row Num
3. Check that the Next RN Seq is correct.
   

   Step 3: Verify the RN Sequence
4. Click Start Outpatient Reg.
   

   Step 4: Execute Registration

Workflow B: Clinical Data Entry

Scenario 1: Outpatient (Individual)

1. Ensure you are on the Patient Summary Page.
   

   Step 1: Ensure you are on the Summary Page
2. Click the gear icon, then change the sheet name to P.LUAR, and set the Row Num to the patient's row.
   

   Step 2: Change Sheet Name and Row Num
3. Click Fetch & Fill Clinical Data.
   

   Step 3: Execute Clinical Filling

Scenario 2: Inpatient (Ward)

1. Ensure you are on the Patient Summary Page.
   

   Step 1: Ensure you are on the Summary Page
2. Click the gear icon, then change the sheet name to P.DALAM, and set the Row Num to the patient's row.
   

   Step 2: Change Sheet Name and Row Num
3. Click Fetch & Fill Clinical Data.
   

   Step 3: Execute Clinical Filling

Scenario 3: Group Counseling

1. Ensure you are on the Patient Summary Page.
   

   Step 1: Ensure you are on the Summary Page
2. Click the gear icon, then change the sheet name to MNT BERKUMPULAN, and set the Row Num to the patient's row.
   

   Step 2: Change Sheet Name and Row Num
3. Click Fetch & Fill Clinical Data.
   

   Step 3: Execute Clinical Filling

6. Troubleshooting Guide

Navigation & Safety Errors

Error / Symptom	Solution
Popup: "❌ IC Mismatch Guard!"	The IC number in your Google Sheet does not match the patient currently open in the MyHDW Portal. Verify you are on the correct patient's file. If the portal is genuinely missing the IC, you can bypass this by unchecking the Strict IC Match Guard in settings. Figure 6.0: IC Mismatch Guard Alert
Popup: "⏸️ The data in row is Unseen..."	Column Q in the P.DALAM sheet is marked as "True". The automator safely aborted to prevent filling out a blank form. Figure 6.1: Unseen Patient Bypass Alert
Popup: "No Inpatient Visit found earlier than ...... Check portal dates."	1. Check Dates: Ensure Sheet date matches Portal. 2. Expand View: Scroll down in SMRP and change items per page to All or 20. Figure 6.2: Expanding items per page in SMRP 3. Not Registered as Inpatient: If the error persists even after changing the items per page setting to 'All', it means the hospital registry didn't register this patient as 'Pesakit Dalam'. You are required to create an RN using the "Start Outpatient Reg" button. After creating the RN, click the "Add SS" button > "Dietetic" to enter the data entry page, then click the "Fetch & Fill Clinical Data" button. Figure 6.3: Manually registering and entering Dietetic page
"⏳ Timeout: MyHDW Portal took too long..."	The portal took longer than 15 seconds to load the form. Refresh the portal page and try clicking the extension button again. Figure 6.4: Timeout Safety Alert

Data & Connection Errors

Error / Symptom	Solution
"Auth Failed" / Connection Failed	You authorized the wrong Google account. Click Sign Out button in the extension, then click Test Connection and select your @moh.gov.my email. Figure 6.5: Connection Failed Error

7. View Modes

You can customize how the extension appears on your screen.

Option A: Sidebar Mode (Recommended)

Best for continuous data entry. The panel stays open while you navigate.

1. Right-click the SMRP Automator icon.
2. Check "Open in Side Panel".
3. Click the icon to open the persistent side panel.

Option B: Popup Mode

Best for quick, single-use actions.

1. Right-click the extension icon.
2. Uncheck "Open in Side Panel".
3. Click the icon to open as a floating window.

---

8. Features Settings

You can toggle the following automation features directly from the settings panel:

---

9. Data Mapping Logic

The Automator uses a "Mapping Engine" to translate your Google Sheet terminology into the specific clinical categories required by the MyHDW portal.

A. Discipline Mapping (`disciplineMap`)

Sheet Value (Malay)	Portal Category (English)
PEDIATRIK	Paediatrics
GENETIK / METABOLIK	Clinical Genetics
OBSTETRIK / GENEKOLOGI	Obstetrics & Gynaecology
PEMBEDAHAN AM	Surgery
ORAL SURGIKAL	Oral Maxillofacial Surgery
ORTOPEDIK	Orthopaedics
MEDIKAL	Medicine
HEMATOLOGI	Clinical Haematology
REHABILITASI	General Rehabilitation Medicine
HEPATOBILIARI	Hepatopancreatobiliary (HPB) Surgery
PLASTIK SURGIKAL	Plastic & Reconstructive Surgery
PSIKIATRIK	General Psychiatry
ORL	Otorhinolaryngology
ONKOLOGI	Surgical Oncology
RAWATAN RAPI	Adult Intensive Care
KECEMASAN	Emergency Medicine
RESPIRATORI	Respiratory Medicine
NEFROLOGI	Nephrology
UROLOGI	Urology
DERMATOLOGI	Dermatology
KARDIOLOGI	Cardiology
NEURO SURGIKAL	Neurosurgery
NEUROLOGI	Neurology
OFTALMOLOGI	Ophthalmology
GERIATRIK	Geriatric
Hepatology	Hepatology

B. Diet Type Mapping (`dietTypeMap`)

Sheet Value	Portal Selection
MODIFIKASI_KONSISTENSI	Diet Modifikasi Konsistensi
TERAPUTIK	Diet Teraputik
PIAWAI	Diet Piawai

C. Specific Diet Codes (`specificDietMap`)

Multiple codes can be entered in one cell (e.g., DD, LSD).

Sheet Code	Full Clinical Diet Name
DD	Diet diabetik
LSD	Diet rendah garam
LCHOL	Diet rendah kolesterol
LFD	Diet rendah lemak
LCD	Diet rendah kalori
HCD	Diet tinggi kalori
LPD	Diet rendah protein
HPD	Diet tinggi protein
LPUR	Diet rendah purin
LK	Diet rendah potasium
HK	Diet tinggi potasium
LCOPPER	Diet rendah kuprum
LPO4	Diet rendah fosfat
LVK	Diet rendah vitamin K
LFIBRE	Diet rendah serat
HFIBRE	Diet tinggi serat
LOXALATE	Diet rendah oksalat
IEM	Diet inborn error metabolisme (IEM)
KETO	Diet ketogenik
Bland	Diet bland
LSALICYLATE	Diet rendah salicylate
LACTOSEF	Diet tanpa laktose
GLUTENF	Diet tanpa gluten
TONSILECTOMY	Diet tonsilektomi
NEUTROPENIC	Diet neutropanik
UCAT	Diet ujian UCAT
REGIM FORMULA ENTERAL	Regim formula enteral
DIET CECAIR JERNIH	Diet cecair jernih
DIET MINUMAN BERKHASIAT	Diet minuman berkhasiat
DIET KISAR	Diet kisar
DIET BUBUR CAMPUR	Diet bubur campur
DIET CINCANG	Diet cincang
DIET LEMBUT	Diet lembut
DIET PUREE	Diet puree

10. Adhoc Query Reporting (Admins Only)

🛑 This section is for SMRP Administrators only. Regular dietitians cannot access the Adhoc Query Report builder module.

This section provides a guide for administrators on how to construct an adhoc crosstab report to visually audit data mapping results. To generate the exact report shown in the sequence, follow the steps below by dragging the correct tags from the list of available fields into the appropriate shelves.

Configuration Sequence Instruction:

Log in to SMRP with administrator privileges, open the Adhoc Query tool, select the **"Dietetics Individual RN Reporting"** datasource, and perform the following sequence:

1. Select Columns (Measures): Locate the **Measure** folder in the left panel. Drag the following numerical fields into the **"Column"** shelf:
   • DATE_ENCOUNTER_YEAR
   • NO_OF_ENCOUNTER
   • DATE_ENCOUNTER_MONTH_IN_YEAR
2. Select Rows (Dimensions): Locate the **Dimension** folder in the left panel. Drag the following clinical grouping fields into the **"Row"** shelf, in this exact order to match the audit view:
   • THERAPIST_FULLNAME
   • DATE_ENCOUNTER
   • VISIT_SERVICE_L1
   • PATIENT_CLIENT_RN
   • DIET_CONSULTANT_TYPE
   • DISCIPLINE_NAME
   • PATIENT_TYPE
   • PATIENT_AGE_DETAIL
   • VISIT_TYPE
   • REFERRAL_SOURCE_TYPE
3. Execute Report: Once the fields are correctly placed, click the **"Show"** button in the header bar to generate the cross-tabulation audit table.