LinkedIn
Twitter
Google Workspace and AppSheet can help automate processes and workflows through easy-to-use desktop and mobile applications, complete with chat bots, dynamic emails and notifications.Our customers also often integrate their applications with their favorite APIs and Google Cloud tools to enrich their solutions, including BigQuery, Looker, Vertex AI, etc.
Google Workspace and AppSheet ensure a connected workforce and accelerated productivity for any industry - including Retail, Manufacturing, Financial services, or Healthcare and Life Sciences.
Common use cases for Healthcare and Life Sciences are around hospital resource management, shift scheduling, PTO or vacation scheduling, medical equipment tracking and maintenance, audits, and workplace safety. AppSheet, with Google Workspace, helps Healthcare companies address their top challenges of cost pressure, workforce burnout, data management and consumer preferences.
Hereโs an example of an AppSheet application that helps with bed allocation and shift scheduling of Healthcare workers. This template showcases three personas: Administrator, Shift Manager, and Staff. The app helps with the following activities:
Administrator
- Access to data on shifts, assignments and overtime (optionally connect to a big data source like BigQuery)
- Dashboard on shift metrics
- Manage security and governance through the AppSheet editor
- And moreโฆ
Shift Manager
- Bed allocation
- Shift scheduling
- Workload Forecasting (users may choose to power this using Vertex AI)
- View reports and summaries
- And moreโฆ
Staff
- Clock in / out of shifts
- Request cover
- Review assigned tasks
- And moreโฆ
To get started, clone the app using the app definition link. You may have to add your profile to the Employees and the Settings tables in the source file. To view the template, use this browser link. To copy and modify it, use the app definition link.
Fig. 1 Change shift capacity based on forecasted demand to avoid burnout (can be powered by Vertex AI)
Fig. 2 Leverage Dynamic emails, assign/un-assign employees based on their availability
Fig. 3 Employees manage shift signups
Fig. 4 Ensure there is no privacy violation
We would love to hear your feedback for this template. Check it out, clone, the app, and get started with this link.
Authored by:
Very nice. Just one little thing. I don't believe that you want to be able to add new beds. I think so because If so you should remove the "Add Pin Button".
The Problem is: We cannot really define the appearance of this button. Because we cannot see it unter Actions.
Here is a way to hide this button: https://www.googlecloudcommunity.com/gc/Tips-Tricks/Hide-add-or-pin-button-on-map-view/m-p/450781
