JAGSTARS: Just A Google Sheet Tracking And Reporting System

JAGSTARS comprises a suite of web-based applications built on Google Workspace tools, including Sheets and Docs, with additional functionality provided by the Javascript-based Google Apps Script platform. The applications encompass:

• Client Relationship Management (CRM) Database: Maintains professional development records.
• Data Upload Tool: Easily adds event data to the CRM, validated before inclusion.
• Report Generation Tool: Provides insights into individual and departmental participation.
• Support Ticket Application: Tracks day-to-day staff interactions with clients.

JAGSTARS employs relational Google Sheets for data storage, associating user records with specific professional development events or support requests through email addresses or unique employee IDs. The support ticket system, designed as a single-page web application, implements different workflow stages, filtering, and notification features, streamlining ticket processing and communication.

Github