Version: 1.5
Last Updated: March 2026

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.
   

   Step 1: SMRP Portal Login
2. Search for the patient using their IC number.
   

   Step 2: Searching by IC
3. You must land on the Patient Summary Page. The extension will only work 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. Uninstall and reinstall 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.