Wins page

Wins page

Current process for wins to appear on the wins page

• User fills out form

  • Form answer goes onto a spreadsheet automatically

  • A GitHub Action uses Google App Script to create 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

    
    • Submission is reviewed by product (in the spreadsheet)
    • A formula reformats a copy of the answer into another sheet in the spreadsheet for review
    Screenshot of user response in review sheet

    
    • If acceptable, mark true for show on website
    • If exceptional, mark true for showing on about page
    • If not acceptable, mark false for show on website
• GitHub Actions checks spreadsheet monthly and updates which rows should appear on website.
• 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.

Automations related to the process

• As soon as a user submits the survey form, an On form submit trigger in the Google Apps Script adds the information to a spreadsheet as well as creates an issue to be added to our project board
• Another monthly trigger in the same Google Apps Script, creates a Pull Request which if merged adds the new row added to the spreadsheet to the Wins page on the website.

Resources

Note: Permissions to these resources might be restricted due to sensitive user data, please reach out to leads for access requests.

• HfLA Website Admin Folder