I need a database set up which collects members profile details. Each member of my website needs a username/password where they can then view and edit their own profile details. Changes need to automatically be reflected in the database. All my current databases (excel spreadsheets) need to be entered into the new database. This new database must look the same as current one, with ability to sort and filter by each column.
Ability to change profile forms as needed.
I want to be able to create areas of my website where only members can view.
## Deliverables
1.? ? ? ? ? ? Username/password for each member
2.? ? ? ? ? ? Information from profiles goes directly into database
3.? ? ? ? ? ? Members able to login and edit profile details ??" changes reflected in database
4.? ? ? ? ? ? Database to look as current one (able to sort/filter by each separate field)
5.? ? ? ? ? ? Able to create secure pages where only members can access
6.? ? ? ? ? ? Current excel spreadsheets input into new database
7.? ? ? ? ? ? Ability to change profile forms as needed
?
Website ??" [[login to view URL]][1]
?
Current Profile Forms can be found at:
Singles:? ? <[login to view URL]>
Couples: <[login to view URL]>
1.? ? ? ? ? ? Current workflow is ??" person goes to website and signs up to become a member by putting their name and email into either the Sydney or Melbourne form (this is through Aweber)
2.? ? ? ? ? ? They receive a Welcome Email with the links to the profile forms
3.? ? ? ? ? ? Some members fill out form, some do not (depending on what type of dinners they want to go on)
I want all members regardless of whether they have completed a profile form to have log in details as I want to set up pages that only member can access
?
? I need to be able to sort and filtered by each column. I have 4 databases (1 for NSW singles, 1 for NSW couples and the same for VIC).