Our grotto is looking for a better way to manage membership data and process membership applications. I am hoping to get some information about how other grottos manage their membership to see if that might work better for us.
Currently we have the membership applications coming through an online form that go to a spreadsheet. From there the data is managed through several other spreadsheets and everything is processed manually, including confirmation emails and such. This system is too hard for busy volunteer cavers to keep up with.
What we need is a software system that will send membership application data from the website into a spreadsheet. From there it will automatically send confirmation emails to the submitter and to the grotto. We need to be able to easily manage, notate, and update the information for each member so we can track things like dues payments on a personal level.
Does anybody have a suggestion for something that would work well for us?