I’ve just discovered AirTable and think it could be an amazing tool for Communications and Student Enrollment work that I’m doing with our non-profit gymnastics club.
Is the following possible?
- Student Data Base: birthdates, levels, etc, parents, ph# - important is contact email
- Events Data Base: 15 or so events will be attended - not all students attend all events - (students event schedules are set according to their Team/Group). In addition to students attending, this data base also needs date, location, schedules, etc - and possibly $cost info
- Group/Team Data Base: students are categorized 6-8 different groups; a student may be in more than 1 group - different groups attend different events
Enrollment
- basically eligibility to attend an event depends on the Team/Group the student belongs to
- multiple Team/Groups attend multiple events
- student don’t necessarily attend all events they are “invited” to
Needs
To track enrollment of students for the various events
Some kind of RSVP feature - where parents confirm what events they are attending or not attending
Hoping this can be automated via mail merge email - where “invites” are sent and responses are automatically recorded - Thinking that the parent contact can be emailed a Form with yes/no responses for each event - the form should be specific to the events the student is “invited” to
Less important but still appealing is the ability to “publish” the events via a shared view, mail merge email, or on our website: including the list of who is RSVP enrolled
Nice would be to also include the $ cost info for each event - then pull that info into a total cost per student / group
I’ve played around for a few hours now on this and can’t quite see how to pull it off.
If this is possible, I’m sure we would consider hiring an expert to help us implement it.
Thoughts?
Is anyone interested in taking on this project?