Hi all,
Chimera has grown significantly in the last few years and I found (last year in particular) that the systems that worked fine for a 60 person convention fail horribly in the face of the 120+ person monstrosity we have now reached. Presently, when someone fills out a form on the Chimera website, I receive an email to the Chimera inbox and I manually put all the data into an Excel spreadsheet. I would really like it if a wonderful technically capable someone (or someones) would be able to build me a system that did the following things:
- People fill in a nice form on the Chimera site and all the information they put in gets sent into a database that exports to Excel.
- I’d like it to have fields for me to edit, particulary in marking if each registrant has paid or not paid.
- Ideally, this database would allow me to view lists of people who have paid, haven’t paid, requested accommodation, did not request accommodation, requested food, did not request food, have paid for food, have not paid for food etc.
- Keep a record of the games people requested to be in (first and second choices for each round)
- Separate from that and uneditable by the user, somewhere where I can enter in what games each person is confirmed for
If someone is very fancy, it would be great if it was a database a bit like the nzLARPS membership database where people had individual log ins and could view what they had requested and what games they were confirmed for.
I do not need the database to allocate people to games. That’s a manual process and with good reason.
Please keep in mind that this is a wish list, and while I’m pretty good at using databases, I have no concept of how difficult they are to build. At the end of the day, I’d settle for something that recorded what people plugged into a form and exported it to Excel so I don’t have to manually retype each of the 120+ registrations and game selections.
Thanks in advance,
Anna