Wins page
- User fills out form
-
Form answer goes onto the response tab of a spreadsheet automatically.
-
A Google Apps Script uses the access permissions of a bot account and creates an issue on the project board notifying us that the new submission needs to be reviewed
Screenshot of an issue created by the bot account
- An
On form submittrigger runs a function which reformats a copy of the answer from the response tab onto the review tab in the spreadsheet for review - Submission is reviewed by product (in the spreadsheet)
Screenshot of user response in review sheet
- If acceptable, PM marks true for show on website
- If exceptional, PM marks true for showing on about page (this functionality might not be fully implemented yet)
- If not acceptable, PM marks false for show on website
- An
-
- The Google Apps Script checks the spreadsheet monthly and creates a pull request for rows that should appear on website.
- When the pull request is merged, the data in _wins-data.json file gets updated and the wins.js file uses the json file to display the data on the Wins page. (Note: we are in the process of changing how the json files are generated, so this line item might need to be reviewed and updated again if required)
- Once a month, new wins might appear on the Wins page on website if the user entry is approved by PM and the related PR has been merged.
- As soon as a user submits the survey form, an
On form submittrigger in the Google Apps Script adds the information from the response tab to the review tab in a spreadsheet in a specified format. - At the same time another
On form summittrigger creates an issue to be added to our project board. - Next a
time-based triggerwhich triggers monthly, in the same Google Apps Script, creates a Pull Request which if merged adds the new row (in the spreadsheet with a True value in the Display column) to the Wins page on the website.
- Check if the issue requires you to gain access to the HfLA Website Admin Folder, if yes, reach out to the leads requesting appropriate access permissions.
- If you need to work on the how the data from json file is used by wins.js to display on the wins page, you might not need access to the HfLA Website Admin Folder, but if you need to work on anything related to how the json file is generated, you will probably need access to the folder. If you are not sure, please check with the leads.
- Go through the Wins form admin guide for detailed information on how the workflow (up until generation of the json file) is set up.
- Make copies of all the files needed (from the HfLA Website Admin Folder) in your own drive and test out the code changes. No code change should be made to the production script.
- Once approved the leads would add the code changes to the production script.
Note: Permissions to some of these resources might be restricted due to involvement of user data, please reach out to leads for access requests. Also, the list of resources is not comprehensive for security reasons, but the Wins form admin guide has detailed information on what resources you might need.