Use your power for good ...

[Andrew Roberts]

https://covid-global-hackathon.devpost.com/

globalcovidhackathon.slack.com

Any ideas for what the Apps Script community could do to contribute??

Amit's made a start with his COV19 India tracker.

[Alan Wells]

Personal Protective Gear Inventory System

- Daily inventory level check - Input Form for workers - Form submitted every day

- Database for inventory - Tracks current inventory

- Automatic Approval and communication to those who need to distribute the supplies

- Report generation for current inventory status

- Graph usage against a graph of re-supply - Predictive Analysis

- Automatic approval and communication to suppliers when inventory drops to a certain level

- Receipt generation for supplies issued - PDF

- Acknowledgment of receipt of supplies - confirmation back to inventory database

- Loss prevention and mitigation procedure automated

- Automatic reporting of the failure of the receiver to acknowledge receipt of supplies

- List maintenance of approved suppliers/vendors and approved requisitioners

- Input system for inspecting and receiving supplies in

- Automatic communication to the dept/person who pays for supplies when a new shipment comes in

- Google Sites website builder - Automate the building of a Google site, that will be used for the Personal Protective Gear Inventory System

Most large organizations will already have an inventory/purchasing/inspection/receiving system, but small organizations like a volunteer ambulance service, small towns, or individual departments within a larger organization that track supplies internally, or places with no money for a computerized system, might use it.

[Alan Wells]

Online Ordering System

- For food service businesses transitioning from "eat-in" to "take-out"

- Google Sites and Google Form templates for an online ordering system

- Automatic alerts to the customer and to the kitchen when an order is approved

- Automatic communication back to customer when their order has been relayed to the kitchen

- Spreadsheet automatically detects orders of the same type for efficiencies in preparation

- Track time from order approval to order starting in kitchen and from kitchen to completed

- Predict time from order entering kitchen to when the customer can arrive for pick up

- Stagger customer pick up times for social distancing - Pick up times calculated by the system

This would be for small restaurants who don't have the money, especially if all their business is now gone, for setting up a basic system quickly.

[Andrew Roberts]

I've repurposed Amit's dashboard for Welsh regional data - for all you Welsh devs out there ...