Database version 2Back to Databases
The database had now got to change as it was no longer an emailing system, as I had exported all the records into Mailchimp. At this point I had to change the structure of the database because of it's complexities and preparing it to be a mailing database. I also redesign the site. To keep the history of the emailing system, I kept this, and introduced a new grouping system. Currently the live system holds 110,000 member records.
Add/Edit/Delete Groups to member record
Add/Edit/Delete incidents/contact responses to the member record
Edit members incidents
Add/Edit/Delete members giving record
Edit members giving record
- List all the people who have given descending.
- Show the weekly giving.
- Set up banking dates
- Export today logging of today's financial transaction to excel by database user so to be used for mail merge
- Export transactions linked to a campaign group.
- Show breakdown of figures for a campaign which then can be exported to word
- Transaction log