Scheduling

RGB DEV brought automation to the scheduling workflow at KCHUNG Radio.

Assessment

KCHUNG's programming schedule was updated and maintained in two different places, Google Calendar and kchungradio.org. With each calendar change, a scheduling staff member had to manual migrate updates from google calendar to kchungradio.org.

Google Calendar was serving as an effective internal tool for scheduling, but could not be shared publicly due to sensitive information being stored in the event description.

Manual Workflow

Staff Gathers Data

from Google Calendar

Staff Filters & Posts Data

to kchungradio.org

Staff Gathers Data

from Google Calendar

Staff Filters & Posts Data

to kchungradio.org

Goal

Remove manual maintenance of multiple sources of data and give KCHUNG's listeners a reliable and up-to-date source of truth for program schedules.

Solution

Workflow Automation

Server Requests Data

from Google Calendar

Google Responds

w/unfiltered data to server

Website Requests Data

from server

Server Responds

w/filtered data to website

Server Requests Data

from Google Calendar

Google Responds

w/unfiltered data to server

Website Requests Data

from server

Server Responds

w/filtered data to website

RGB DEV automated the scheduling workflow so the website is always up to date. On request, the server asks Google Calendar for information, so it always gives the website the latest data. Staff members only need to update the Google Calendar.

Next Case Study