Form creation, database-driven

Closed

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 *@[url removed, login to view], 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 [url removed, login to view])

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: PHP, SQL

See more: what is database entry, what is a fan sign, what is a data entry form in a database, website creation system, website creation order, terms of agreement form, sql data entry form, school project first page, process of website creation, pick-n pull, page personnel, out of scope requirements, online website creation, online database php, matches list, list matches, how to develop website like facebook, how to develop webpage, how to develop database in access, how to develop a website like facebook, domains edu, access database data entry form, php email submit form maker sql database, csv mysql

Project ID: #472496

11 freelancers are bidding on average $520 for this job

vsscomputers

Hi Please check PM for details

$400 USD in 4 days
(60 Reviews)
6.0
jason18505

I'm a full time web developer for a company in Wisconsin. I also do some side contract work for another company out of WI. I have the php and mysql skills that will be required for this project. Thank you for consideri More

$500 USD in 5 days
(5 Reviews)
3.6
gafhus

Ready to start.

$450 USD in 5 days
(8 Reviews)
3.6
zaycker

It would be before 29 july. Small group of designers and programmers. We are novice here. Wanna do it on drupal engine.

$700 USD in 8 days
(1 Review)
2.4
isdevel

Hi, check private message board please

$650 USD in 9 days
(1 Review)
1.3
creativesol

ready to start

$750 USD in 10 days
(0 Reviews)
0.0
devroot

Thanks for the very detailed functionality outline. We can meet the deadline, however, we would need to start quickly. Please see PMB for more details. -Ali

$675 USD in 7 days
(0 Reviews)
0.0
pediasoft

Professional Web Application Developer. Works with both ASP.NET and PHP. 10+ years in the programming field. Fluent in English and got no problems working across time lines.

$300 USD in 7 days
(0 Reviews)
0.0
powerongaf

Check your PM please.

$450 USD in 5 days
(0 Reviews)
0.0
baymix

I can start immediately and complete this project before 7/29.

$400 USD in 5 days
(0 Reviews)
0.0
digitalbd4

Dear sir, We are from bangladesh. We are from a company name digital Bangladesh. We established 01-01-09 in Bangladesh. We work localy for many website development. Now we want to work world wide. We are always con More

$450 USD in 21 days
(1 Review)
0.0