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 Google Apps Script 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

    
    • Submission is reviewed by product (in the spreadsheet)
    • An On form submit trigger runs a function which reformats a copy of the answer into the review sheet in the spreadsheet for review
    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 hasn't been implemented yet)
    • If not acceptable, PM marks false for show on website
• The Google Apps Script checks spreadsheet monthly and creates a pull request for rows that 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 from the response tab to the review tab in a spreadsheet in a specified format.
• At the same time another On form summit trigger creates an issue to be added to our project board.
• Next a time-based trigger which 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.

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