Skip to content
UC Berkeley Family Housing Scheduler & Automatic Notification Web App
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
app
bin
config
db
features
iterations
lib
log
public
script
spec
vendor/assets
.codeclimate.yml
.coveralls.yml
.gitignore
.simplecov
.travis.yml
Gemfile
Gemfile.lock
LICENSE.md
README.md
README.rdoc
Rakefile
client_secret.json
config.ru
google_sheet_api_credentials.yaml
sample_email_view_1.jpg
sample_email_view_2.jpg

README.md

UCBerkeley_Housing

UC Berkeley Family Housing Scheduler & Automatic Notification Web App

Members

  • Min
  • Sora
  • Erick
  • Abby
  • Nathan

Links

App Goal

  • 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.

Requested Feature

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

App Description

  • 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.

Sample Automated Notification Email View

New Schedule

Alt text

Schedule Cancellation

Alt text

Code Climate

Test Coverage

Issue Count

Build Status

You can’t perform that action at this time.