Query - create a spreadsheet to use for the mail out
- Dominant language
- JavaScript
- Stars
- 23
- Forks
- 62
- Avg merge
- 24m
- Merged PRs (30d)
- 1
Description
We want to send the following email to everyone currently using Online Banking:
https://www.figma.com/design/eRPbcgyiL2ViPPKyyTdLm5/Auth---Product-and-Payment-Updates?node-id=6630-677&t=IdNIgeRgPSd3pt3y-0
The OCM team is able to use GCNotify to send the emails, driven from a spreadsheet.
For this ticket, please create a spreadsheet with the admin emails and CFS account number for each BCROS account that is currently using Online Banking.
Note that some accounts have more than 1 admin. Also note that some accounts may have changed away from OB, so only include those that are currently using OB.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by identifying the data source for BCROS accounts, their admin emails, CFS account numbers, and current Online Banking status. Build the spreadsheet for accounts still using Online Banking, include every admin where there is more than one, and verify that accounts which moved away from Online Banking are excluded.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgres
- Domain
- database
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 55/100