Workflow Expert: Jotform & Google Sheets "Closed-Loop" Accountability System Workflow

Customer: AI | Published: 14.01.2026
Бюджет: 350 $

I am looking for a developer to build a proprietary performance-tracking system for a team of 100+ athletes and 10-12 team captains. Core Workflow: • Master Data: Sync an external roster (Google Sheets/ARMS) to Jotform. However, if this is challenging, we can do a manual download of the team db from ARMs on a frequent basis, if necessary. • Dynamic Point Reference Table: A central, modifiable table (in Google Sheets or Jotform Tables) that stores point deduction values for each incident category. The system must pull values from this table so that, if a point value is modified, future incidents are automatically calculated at the new rate. • Coach Input: A Jotform App for coaches to log incidents with a "Wheel Picker"/Select2 player selection and automated point-deduction logic. • Automated Workflow: An immediate email "nudge" to the player, and a "task notification" to the assigned Captain. • Loop Closure: Captain must log a face-to-face discussion via a pre-filled form to "finalize" the point deduction. • Real-time Dashboard: A live, public leaderboard ranking all 100 players by net points and a "Captain Efficiency" report. Required Tools: Jotform (Workflows, Tables, Report Builder), Google Sheets. (Note: I prefer to keep this native to Jotform/Google Sheets to minimize costs, but I am open to Zapier/Make.com if necessary for the live sync). Legal: NDA and Work-for-Hire agreement required. All logic and architecture remain my proprietary property. Budget & Administrative Note: This project is for a University Athletic Department with a firm, fixed-price budget of $350 for this phase. We are currently applying for the Jotform Education Discount (50% off) to manage long-term software overhead. This is an ideal project for an expert looking to add a high-profile collegiate program to their portfolio. We provide clear documentation, a signed NDA, and a commitment to a professional testimonial and 5-star review upon successful delivery.