Keep your whole team posted on ED hold counts
Every hour, WebRun opens TeleTracking, counts patients currently held in the ED with an admit or transfer order, breaks the count down by admitting service, logs it to a Google Sheet, and posts a status update to Microsoft Teams so bed management always knows where holds stand right now.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I get an hourly status update on ED hold counts?
WebRun pulls the current ED hold count and average hold hours from TeleTracking every hour, breaks it down by admitting service, and logs each hour as a row in a Google Sheet. It then posts a status update to Microsoft Teams so bed management always knows where holds stand right now and which service is holding the most patients.
- Hold counts are visible every hour instead of only at shift huddle
- The admitting service holding the most patients is named automatically
- A full day over day trend builds itself with zero manual logging
Built for bed management teams · hospital capacity managers · ED charge nurses · nursing administration
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.teletracking.comin a real browser with your saved login - no setup, no API keys. -
1
TeleTracking - pull the current hold count
teletracking.com How to Automate TeleTracking
WebRun opens TeleTracking to pull the current hold count. - Open TeleTracking and count patients currently held in the ED with an admit or transfer order
- Calculate average hold hours across the current group
- Break the count down by admitting service
- Compare this hour's count against the same hour yesterday
Done when The current hold count, average hold hours, and service breakdown are captured.
-
2
Google Sheets - log hourly hold totals
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log hourly hold totals. - Open the ED Hold Status log
- Append this hour's count, average hold hours, and service breakdown as a new row
- Keep a running column for the day over day comparison
Done when The log has an hourly row with the count, hold hours, and comparison.
-
3
Microsoft Teams - post the status update
microsoft.com How to Automate Microsoft Teams
WebRun opens Microsoft Teams to post the status update. - Post the current hold count and average hold hours to the bed management Teams channel
- Call out any admitting service holding more patients than usual
- Link to the Google Sheet for the full trend line
Done when Bed management has this hour's hold status posted in Teams.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does this count include boarders waiting on any bed, or only formal holds?
It counts patients in the ED with a confirmed admit or transfer order who have not yet moved, which is the standard definition of a hold in TeleTracking.
Will it alert anyone outside the hospital about hold counts?
No. The hourly status stays internal, posted only to your bed management Teams channel and logged to your own Google Sheet.
Can I see whether holds are trending up or down?
Yes. Every hour is logged as its own row with a day over day comparison, so the Google Sheet builds a trend line automatically.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.