Multi-Project Tracker

A fun project that relies on multiple people interacting with a Google Form to input upcoming projects.

The form can be accessed as a standalone page or as a sidebar into the main Dashboard.

The form inputs responses in the Admin page.

The project relies on an Admin page that only a select few can access and edit.

The main Dashboard can be published and viewed by anyone, with restricted access to formulas or filters.

A python script hosted on a different server scrapes information that is submitted via Google Forms and calculates scores for each project and updates the Admin Page with pictures and values.

These values are reflected in the Dashboard file.