Auto-Fill Repetitive Web Forms: Reports, Applications, Registrations

Use Case: Weekly Government HR Report

An HR manager at a mid-sized company submitted a mandatory government workforce report every week. The form had 30 fields: employee counts by category, working hours, overtime, training hours, safety incidents, and various statutory totals. The values changed slightly week to week, but the structure never changed. Filling it manually took 45-60 minutes of focused work.

About 80% of the fields had the same values as the previous week. The HR manager was essentially re-entering the same data with minor updates, every single week, for years.

Data File Approach

We created a simple key=value data file that the macro reads from Notepad. The HR manager updates the values that changed week to week (typically 4-6 fields), saves the file, and runs the macro. No spreadsheet formulas, no complex tooling.

# weekly-report-data.txt
company_name=Acme Manufacturing Ltd
report_week=2026-W08
total_employees=247
full_time=198
part_time=49
overtime_hours=312
training_hours=28
safety_incidents=0

Recording Browser Navigation

The macro navigates to the government portal URL, waits for login (if not already authenticated), then navigates to the report submission page. We recorded the navigation steps with Repio (F5 to start), clicking through the exact path: portal home, HR section, weekly report, new submission form.

Key timing insight: government portal pages often load slowly. We added 3-4 second wait delays after each navigation step to account for variable server response times. These conservative delays added 30 seconds total but prevented the macro from clicking before the page finished loading.

Filling Fields and Screenshot Confirmation

Field filling uses Tab-key navigation throughout the 30-field form. For dropdown fields (like region and department), we used keyboard shortcuts: Alt+Down to open the dropdown, then arrow keys to select the value. For checkboxes, a simple Space key toggles the state.

action_type,button,x,y,delay_ms,comment
key,tab,,,80,Move to next field
key,ctrl+a,,,50,Select existing value
key,ctrl+v,,,100,Paste from clipboard
key,tab,,,80,Next field

After clicking Submit, the macro waits 2 seconds for the confirmation page, then triggers Win+Shift+S (Windows Snipping Tool) to capture a screenshot of the confirmation number. The screenshot is automatically saved to the desktop with a timestamp filename.