We are a non-profit organization organizing meetups and summer camps for kids who wants to learn how to code. We based our website on WordPress and a simple form tool in which the parents could register their children for meetups and summer camps. Unfortunately this approach is so time consuming when we try to send out emails, for example, as we have to export the member data from the form into a csv-file, and then import it to MS Excel and then get rid of all the duplicates generated by parents registering two or more kids for example. And with the current form, we do not have enough control of the data entered into our system, which means that we have to do a lot of manual data cleaning afterwards.
And when the parents wants to sign up their kids for a meetup, they have to re-register all over again...
Ideally I guess we would like to have a system in which an adult/parent, register one or several children and their spouse, and then can log in back to register for an event and do not have to re-enter the same information again! And with this ideal system, we would like to be able to send out emails to a subset of parents and/or kids to communicate with them. So I guess this would be a combination of a membership database (where one parent can register several "child members") and an event manager where we can publish events which the parents can book, and be able to send out emails or export contact data that can be used in other systems to send out text-messages for example, etc, etc.
But is all this really doable in WordPress?
I would be very grateful if you could give me some piece of advice on this issue!