• Events are created and maintained via a google form, which writes the submitted data to a specially formatted google sheet, using Form Publisher

  • On the Form submission page we capture the form edit URL so that we can edit the contents of the workshop. When this edit occurs, the document (sheet) is updated.

  • We use Data Studio as a front end to search for the list of PD opportunities. This allows for filtering and sorting the list on multiple criteria.

  • On each site page we track and display the number of participants allowed, how many are registered and how many spots remain. The sheet color codes using conditional formatting to provide a visual of remaining spots.

  • Using an Apps Script the event information is automatically added to the google calendar that displays all the events.

  • There is a link on each event page to add the event to your calendar, as well as a calendar link in the email that a registrant receives.

  • In addition to using the Data Studio interface to find events, there are navigation arrows on each page to move forward and backward to each event.