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

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

Sidebar Form
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.

Main Dashboard
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.
0 likes · 16 views · Mar 29, 2023
Project Tracker with user submission