I need custom user database to allow volunteers to login and fill out a simple form to track their volunteerism.
Volunteers need to be able to add as several different types of volunteerism in any given session. For example, login anytime and add different types of activities for the previous 7 months.
The types of volunteerism will be controlled by a drop down menu. I will provide those.
For display purposes, total volunteer hours and types need to display on the home page of the website in its own, simple column. So the snippet needs to aggregate total hours, and also display hours by type.
Due to privacy concerns it is not necessary to display the volunteer name publicly, but a list of the top volunteers can be displayed to the Admin doc group.
I’ve thought through how the tables should function. Maybe this is overkill, and if it is, just let me know.
pk stands for private key. fk stands for foreign key. The key relationship is the first table ties to the web_user_attributes table. Is that going to be possible?
Volunteer Database
Volunteer table
pk_vol_name_id
fk_id_modx_web_user_attributes
fk_vol_hours
fk_vol_type
vol_name_last
vol_name_first
vol_type
vol_hours
Volunteer Hours table
pk_id
fk_vol_name_id
fk_vol_type_id
vol_date
vol_type: from the Type table below.
vol_hours
Volunteer Type table
pk_type_id
fk_vol_name_id
fk_vol_hours_id
vol_type: event, board meeting, classroom, snacks, and others to be added shortly
Start time: now
Deadline: July 15
Budget: you tell me what your rate is and how long you think this will take. I’m not sold on using WLPE for some reason but if you feel like you can pull this off using WLPE, then let me know.
IP: code can be contributed back to the community.
