UCBerkeley_Housing

UC Berkeley Family Housing Scheduler & Automatic Notification Web App

Members

Timely notification of staff of any changes made to their apartment showing schedule. Problem: Apartment showings are added and changed ad hoc, sometimes last-minute, and it is difficult for staff to track due to inconsistent communication between staff and the department scheduling these apartment showings.

Automated email notification of additions/changes to apartment showings to relevant still will remove human error from the communication process.

The app reads from a Google spreadsheet and sends email notifications when a change has been made for a certain CA. From the app, schedule changes made will also be reflected in the Spreadsheet. In order for our app to write and read from the spreadsheet, its access must be set to accessible to anyone with the link.
- A CA can edit their schedule and info from their details page
- Can view everyone’s schedules from the Calendar page
- Admin can add CAs from the CA Info page
- All spreadsheets listed on Spreadsheets page
- Admin can populate spreadsheets
  - Enter the number of the month and year in format: M or MM and YYYY
  - Input the link to a newly created Spreadsheet. Please do not make any changes to the spreadsheet; input the default newly created spreadsheet.
Because the app pulls all its info from the spreadsheet, there is a specific format that the Spreadsheet must follow. In order for the app to work:
- Basic layout and column placement of spreadsheet cannot change
- Time slots must be in 30 minute increments, either at H:00 or H:30
- Can change things like font, color
Some edge cases
- Removing a CA availability from the app will not remove it from the website
- Both scheduling office and CA office may not modify CA column in the Google spreadsheet. Manually modifying the column might make the app to not send a notification email to a corresponding timeslot.