ER: Refactor `wins-form-responses/Code.js` to use Column Status (Project Board Beta)
- Dominant language
- JavaScript
- Stars
- 363
- Forks
- 872
- Avg merge
- 2d 21h
- Merged PRs (30d)
- 18
Description
### Emergent Requirement - Problem
When we shifted over to Project Board Beta last year, the Google Apps Script (GAS) function that generates new Wins Form Data response issues was inadvertently omitted.
We need to remove the references to `COLUMN_ID` in [Code.js](https://github.com/hackforla/website/blob/gh-pages/google-apps-scripts/wins-form-responses/Code.js) (and the corresponding GAS `Code.gs`) and instead use the current GraphQL method of changing issue ('column') status.
### Issue you discovered this emergent requirement in
- #8051
### Date discovered
- 4/7/25
### Did you have to do something temporarily
- [ ] YES
- [x] NO
### Who was involved
@JessicaLucindaCheng @daras-cu @t-will-gillis
### What happens if this is not addressed
New Wins Form issues appear to be placed on the Project Board's "New Issue Approval" column-status, despite the expired functionality using `COLUMN_ID`. However, the GAS function is supposed to move this issue to the "Questions / In Review" column, which does not happen.
### Resources
- Refer to #6993, #6995, and related issues for discussion of Project Board Beta.
### Recommended Action Items
- [x] Make a new issue
- [x] Discuss with team
- [ ] Let a Team Lead know
### Potential solutions [draft]
- In `google-apps-script/gh-requests/Code.js` and in `google-apps-script/wins-form-responses/Code.js` - and the corresponding, actual working code in Google Apps Script (GAS), any and all references to COLUMN_IDS and/or COLUMN_KEYS and similar are no longer correct- GitHub does not use 'columns' in this way anymore.
- Remove all of the outdated references to 'columns'.
- Check if the existing URLs to the Google Sheets are correct, and/or are relevant, and/or whether we should be listing the URL on the public page.
- Determine which (GAS) functions are actually running, and then confirm which status-column new "Wins-Form-Submission" issues should be. Note that on creation, all issues go to "New Issue Approval" status-column.
- If new issues need to go to another status-column, we have an existing `github-actions/utils/mutate-issue-status.js` GraphQL function for mutating status-column.
- It would be ideal if this GraphQL function can be integrated with the working GAS `Code.gs` function. If not, the GraphQL function might be triggered after/ upon issue creation, if the new issue matches some identifier from the "Wins-Form-Submission"- i.e. issue title. a label like `wins-form-submission`, etc.
Contributor guide
Assessment
This issue has not been assessed yet.