Need help to add reports to a website

LadyC

This may not be the right place to post, but please re-direct me if not....

Basically I work for a small charity, which requires reports from our members on a monthly basis. At present we send them a form from our master spreadsheet, which we change for the individual users copy, paste, save, email individually. It's worked up until now, but we have a growing number of members and the process is not sustainable.

I want to be able to link this to our website, so that the individual members log in, go to a tab which holds a form with their individual information, they fill it in and submit it.

The form's details include their organisation's name, and then a list of categories which are directly linked to them. If the category doesn't apply to them, we don't want this to appear on their form. The categories have cells next to them in which they report figures.

Is there a way of doing this? I'm not sure if my request is very clear and I'm not sure how much clearer I can be without giving away too much sensitive information, but if anyone thinks they can help, I'd be willing to have a private conversation if needs be.

Please help if you can!

Thanks in advance...

steve1980

This is a big job. If the form is different for every person then it will require each person's individual form to be uploaded then linked onto the persons personal log in.

S0litaire

Looks like you need a database on your website to generate specific pages (Dynamic pages) depending on the user.

For someone who knows there way around SQL and PHP / ASP it should not be that hard to whip something up...

More info on Dynamic pages:
http://en.wikipedia.org/wiki/Dynamic_web_page

bingo_bango

Worth considering Google Docs?

It's free and allows you to create unique user logins.

LadyC

Thanks all for the suggestions, I will have a look into them and see if it's something we can do ourselves - there isn't much in the kitty at the moment for getting anyone in! I was hoping that it wouldn't be too big a job as each form is effectively the same format, just with slightly different info.

Good shouts though, thanks again

L

paddyrg

It isn't a terrifyingly hard job, but it is certainly not a casual user one to get a professional result. If you need a system to do exactly what you describe, also with some kind of administration interface and reporting/retrieval of that data, it's a 4-5 figure job from a pro/company. It will always cost more than you think it should, once all the admin interface, security, etc is figured out and implemented.

What you *could* try though, is using something like google docs forms - you design a form on a one-size-fits-all basis (so no special filtering for categories for people) which then will populate a spreadsheet. Change it once a month. It won't be ideal, but it'll get you most of the way there for free.