A person adds, updates and archives vacancy pages as roles open and close, and checks that the apply route works. A spreadsheet version is planned but not running.
Websites & CMS
Water utilities
Website
Productised
Cloud
2026
The problem
Roles are edited directly on the site in short, interrupted sessions. Listings go stale when a role is filled. The application route can also be wrong after a change, and applicants reach nobody.
What it does
A producer adds a role, updates the wording or archives a filled role, then confirms the application route works. The demo spreadsheet shows what an automatic helper would read: title, location, status and a closing note. That helper is not running.
Outcomes
Open roles match the latest edit.
Filled roles are taken off the public page.
The apply route is checked each time a listing changes.
The spreadsheet version is still a plan and no job runs.
Simplified mockup
Interactive preview with sample data. Nothing is sent to a server.
Vacancy sheet
Sample sheet for a pass that is specified and not running. Nothing here is written to a live site.
Public page is behind the sheetPublic page matches the sheet
Role
Location
Status
Closing note
Apply path
Leakage technician
Canterbury depot
Open
Closes 31 October 2026
/careers/leakage-technician
Treatment operator
Ashford works
Open
Closes 14 November 2026
/careers/treatment-operator
Customer liaison
Maidstone office
Filled
Filled on 2 October 2026
/careers/customer-liaison
Open until 28 November 2026
Holt Water careers
What the public page will show after this pass.
Leakage technicianCanterbury depot · closes 31 October 2026Apply path does not resolve
Treatment operatorAshford works · closes 14 November 2026
Customer liaisonMaidstone office · filled 2 October 2026Still on the public page
Sampling scientistTonbridge works
Customer liaison left the public page. The other open roles stayed.
Sampling scientist was appended with an Apply button.
The leakage apply path failed the check. The card is flagged.
Public careers page
Careers at Holt Water
Open roles only. A filled role is not listed once the sheet is published.
Leakage technicianCanterbury depotApply path does not resolve
Treatment operatorAshford works
Customer liaisonMaidstone office
Sampling scientistTonbridge works
Apply paths
Role
Path
Check
Leakage technician
/careers/leakage-technician
Resolves
Treatment operator
/careers/treatment-operator
Resolves
Customer liaison
/careers/customer-liaison
Still on the public page
Sampling scientist
/careers/sampling-scientist
Resolves when the role is added
Every open apply path resolves.
How it works
Add a new open role to the careers page, with an apply route.
Update the wording when the role changes.
Archive a filled role so it leaves the public page.
Confirm the application route still works.
A planned spreadsheet version would read title, location, status and a closing note, then repeat these steps. It is not running.
Pipeline
flowchart LR
A[Vacancy sheet] --> B{Status}
B -->|Open| C[Publish or update]
B -->|Filled| D[Archive]
C --> E[Check apply path]
D --> F[Careers page]