Form creation, database-driven

CLOSED
Bids
11
Avg Bid (USD)
$520
Project Budget (USD)
$250 - $750

Project Description:
Below is the scope of the project. Must be functional by July 29th. More details can be provided, just ask!

------------


Develop website with a database-driven data collection system to collect team entries for intramural volleyball program.

Requirements:
- Entries will be collected and stored in an online database
- Each entry will be emailed to authorized personnel once the user presses submit, and it will also be stored in the DB.
- Data can be exported in CSV format
- Data will be viewable in report format online, on a restricted access webpage
- Team captains will be required to verify their school by a school assigned email address
(we'll have a form field where they'll be required to enter their school-assigned email address first. If this matches the address strings we have in the DB, then we will allow them to see the form page, fill out the form, etc. It will be something like *@duke.edu, etc. We'll probably have about 50 or more domains in the "approved address" list)
- Once verified, the team captain will be shown a form to collect all necessary information
- Team captain will be asked to opt-in to support AE on Facebook by becoming a fan
- Team captain will be asked to verify their knowledge that they're ordering shirts and that they
understand the terms and conditions for the AE intramural program
- Team captain will be asked to opt-in to receive email messages from AE
- Counter: limit the number of teams that sign up--max of 50? Pop-up message when limit is reached, with possible redirect
- Email Domain Match: pop-up message indicating that the person needs to use an email address with proper school domain
when they don't have a match
- Shirt description: message letting students know what to expect (colors will vary, sizes will be assigned at pickup, etc.)
- Facebook redirect: redirect browser to American Eagle facebook page once order is complete
- Pickup Instuctions: message explaining how the team can pick up their shirts, what the process is, etc.
- FAQ Page: this could contain more info on the program and any basic questions captains may have



-----------

Form Content:

Field Type Notes
School Drop-Down school names
Team Captian First Name text
Team Captian Last Name text
Shipping Address 1 pre-populated pull from school address database
Shipping Address 2 pre-populated pull from school address database
City pre-populated pull from school address database
State pre-populated pull from school address database
Zip pre-populated pull from school address database
Team Captian phone # numerical formatted
Team Captian school email text email domain match/email format (@email domain.edu)
Team Name Text
Type of Team Drop-Down male/female/co-rec
Sponsorship Agreement Radio buttons
Our team agrees to represent American Eagle in a positive manner by displaying exemplary sportsmanship at all games (Yes/No)
Our team agrees to wear our American Eagle team shirts at all of our games. (Yes/No)
Our team agrees to enthusiastically represent American Eagle to our peers. (Yes/No)

Special Considerations:
Counter-- need to limit the number of teams that sign up--max of 50? Need pop-up message when limit is reached, with possible redirect
Email Domain Match-- need pop-up message indicating that the person needs to use an email address with proper school domain when they don't have a match
Shirt description Need message somewhere letting students know what to expect (colors will vary, sizes will be assigned at pickup, etc.)
Facebook redirect need to redirect browser to American Eagle facebook page once order is complete
Pickup Instuctions need message somewhere explaining how the team can pick up their shirts, what the process is, etc.
FAQ Page this could contain more info on the program and any basic questions captains may have

Skills required:
PHP, SQL
Additional Files: OrderForm.xls
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.