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
- Submission is reviewed by product (in the spreadsheet)
- A formula reformats a copy of the answer into another sheet in the spreadsheet for review
- 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 appear on website if approved.
- As soon as a user submits the survey form, an
On form submittrigger 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.