Enhancing Football Player Questionnaire App
Budget: $50 – $100 USD
Improve Google Apps Script project (questionnaires and real-time dashboard for players and coach)
Project Description
I have an existing project developed in Google Apps Script that manages questionnaires for football players.
The system currently allows completing forms, recording responses, and displaying on a main screen (or Google Sheet) ✓ , ✗ and others signs depending on whether a player has completed the questionnaire.
I would like to enhance this script with the following new features:
1. Duplicated screen (coach view / player view)
Currently, I have a “home screen – coach view” where questionnaires can be completed and ✓ ✗ and other symbols are displayed based on whether players have responded.
I want to create a separate view only for players, where:
Each player can complete their questionnaire and see their own name highlighted in green once submitted.
Players cannot see the status or symbols of others; they should only see the color indicator next to their own name.
When a player submits their response, the coach’s view should automatically update in real time, showing that the player has completed it.
2. Individual responses and player photo
In the current version (coach view), it is possible to answer questionnaires for several players at once.
I want that, in the player version:
Each player can only answer individually.
Upon entering, the system should display the player’s photo, retrieved from the sheet or database where their data is stored.
3. Add 1 new question to the questionnaire
I would like to add one additional question to one of the existing forms.
This new question must be automatically integrated into the RPE form.
The new response should also appear in the automatic reports already linked to the questionnaire (tables, charts, etc.) as an additional metric.
Have to add this answer in the reports. Need to count the number of days that they answer the different questions in the time we filter for.
Add more players in the questionaire:
Increase the amount of players in the questionaire. Currently only can see 36, would like to have the list until 48 players per page max.
Technical details
The project is built with Google Apps Script, linked to Google Sheets (not AppSheet).
It includes an interface in HTML/JavaScript, rendered using HtmlService.
The same UI style and structure should be maintained — only the new functionalities should be added.
The developer should document all changes (code comments and a short summary of modifications).
Expected Deliverables
Updated and fully functional script (.gs files + HTML files if any).
Short setup or deployment instructions (e.g., how to publish both views: coach and player).
Clean and well-commented code.
Project Description
I have an existing project developed in Google Apps Script that manages questionnaires for football players.
The system currently allows completing forms, recording responses, and displaying on a main screen (or Google Sheet) ✓ , ✗ and others signs depending on whether a player has completed the questionnaire.
I would like to enhance this script with the following new features:
1. Duplicated screen (coach view / player view)
Currently, I have a “home screen – coach view” where questionnaires can be completed and ✓ ✗ and other symbols are displayed based on whether players have responded.
I want to create a separate view only for players, where:
Each player can complete their questionnaire and see their own name highlighted in green once submitted.
Players cannot see the status or symbols of others; they should only see the color indicator next to their own name.
When a player submits their response, the coach’s view should automatically update in real time, showing that the player has completed it.
2. Individual responses and player photo
In the current version (coach view), it is possible to answer questionnaires for several players at once.
I want that, in the player version:
Each player can only answer individually.
Upon entering, the system should display the player’s photo, retrieved from the sheet or database where their data is stored.
3. Add 1 new question to the questionnaire
I would like to add one additional question to one of the existing forms.
This new question must be automatically integrated into the RPE form.
The new response should also appear in the automatic reports already linked to the questionnaire (tables, charts, etc.) as an additional metric.
Have to add this answer in the reports. Need to count the number of days that they answer the different questions in the time we filter for.
Add more players in the questionaire:
Increase the amount of players in the questionaire. Currently only can see 36, would like to have the list until 48 players per page max.
Technical details
The project is built with Google Apps Script, linked to Google Sheets (not AppSheet).
It includes an interface in HTML/JavaScript, rendered using HtmlService.
The same UI style and structure should be maintained — only the new functionalities should be added.
The developer should document all changes (code comments and a short summary of modifications).
Expected Deliverables
Updated and fully functional script (.gs files + HTML files if any).
Short setup or deployment instructions (e.g., how to publish both views: coach and player).
Clean and well-commented code.