Fraternity Alumni Website

We are an Alumni Association of a College Fraternity with less than 800 members. We need to upgrade and add some things to our site to include the following:

The website has a public side to the site and a private/secure side of the site accessible only by members of the organization.


A sortable database of members information -

Database Structure:

Field # Type Title Minimum Length

Field 1 Alpha First Name 25

Field 2 Alpha Last Name 25

Field 3 Alpha Numeric Fraternity Number 4

Field 4 Alpha Numeric Pledge Class 8

Field 5 Alpha Numeric Address 1 30

Field 6 Alpha Numeric Address 2 30

Field 7 Alpha City 25

Field 8 Alpha State 2

Field 9 Numeric ZIP Code 10

Field 10 Alpha Numeric Primary Email 30

Field 11 Alpha Numeric Alternate Email 30

Field 12 Numeric Phone Number 12

Field 13 Numeric Alternate Phone Number 12

Field 14 Date Last Revised 10

Field 15 Alpha Numeric Notes (free text) 30

Field Descriptions

Field 1 -First Name – the first name of the member

Field 2 -Last Name – last name of the member

Field 3 -Fraternity Number – membership number

Field 4 -Pledge Class

Field 5 -Address 1

Field 6 -Address 2

Field 7 -City

Field 8 -State

Field 9 -ZIP Code - Zip Code or Zip Code plus 4 – Should automatically format zip +4 as xxxxx-xxxx. If only 5 digit zip code is entered, it should suppress the dash, only displaying or printing it when full 9 digits are entered. Should display an error code if less that 5 digits are entered or more than 5 digits and less than 9 digits are entered

Field 10-Primary Email -Primary email as supplied by the member – bulk email will be sent to this address as well as individual email or blog/chat room communication – This field should require double entry of the email address when the record is first created or when any changes are made to this field. A miss-match of information entered generates an error message.

Field 11-Alternate Email –this address will be used in addition to the primary email address when administrator deems a communication to be a “Special Notice”. Special Notice communication will be used for official organization business or important information for the general membership.

Field 12-Primary Phone Number – this is the phone number that the member designate as his preferred contact phone number. Standard US phone format automatically placing dashes where appropriate, and displaying an error message if full number is not entered. Format xxx-xxx-xxxx

Field 13-Alternate Phone Number – Secondary phone number to be used when primary phone number is not working. Standard US phone format automatically placing dashes where appropriate, and displaying an error message is full number is not entered. Format xxx-xxx-xxxx

Field 14-Last Revised - This is a date field and automatically populates the date corresponding to the date when the account information was last saved. Member cannot enter data into this field, as it is automatically generated when the record data is saved

Field 15-Note – Free text – useful for recording date of death or other information about the account holder

Data should be capable of being sorted by Fields 1 through 9 and Field 14

*** Additional fields required:

Type Title Minimum Length

Alpha Spouse First Name 25

Alpha Spouse Last Name 25

Date field Brothers Date of Birth

Brother Occupation / Field of Expertise – Can be a drop-down with standard occupation choices


Ability to have automatic pre-written email text such as Happy Birthday wishes, Merry Christmas etc send on appropriate date. Dates should be selectable by webmaster and then tied to pre-written text to be emailed.

Ability to automatically email event reminders on designated dates or at various selectable intervals prior the date of the event.

User names will be of an assigned nature, designated by the webmaster.

Passwords should be changeable by the member with the ability to SECURELY send the password to ONLY the member if it is forgotten.

Ability for webmaster or limited designated members to blast email to all members as a "Special Notice"

Links to Social Media - Facebook, Linkedin, My Space

RSS or some way of sending a summary of MESSAGE BOARD posts to member email address if the member so chooses. Additional Choice would be to have each message sent as an individual email or to have none sent at all. However if none is chosen, messages designated "Special Notices" should be sent over-riding this choice.

MESSAGE BOARD - should be capable of being received on mobile devices and receive and post replys from mobile devices.

Work must be tested bug free and operational prior to implementation. Must be completed and implemented in a timely manner - please quote required time to complete and test.

View current website at [url removed, login to view]

Skills: Forum Posting, Website Design

See more: www facebook com free data entry, work spouse, where is social media used, website phone number design, test board, standard website format, social media expertise, sending free bulk email, secure message board, room summary, room design website, printing website design, primary website design, pre written email messages, pre-written email, numeric data entry test, number board design, mobile phone website format, media room design, media match, media design names, linkedin phone number, implementation of data structure, free website forum, free website design forum

About the Employer:
( 0 reviews ) Eynon, United States

Project ID: #584655

15 freelancers are bidding on average $702 for this job


We will provide you the best services, Please check the PMB for more details.

$650 USD in 22 days
(9 Reviews)

hi please check PMB for more details

$735 USD in 25 days
(5 Reviews)

its ok, i am good in website design and developmental work and have expertise in flash so it will be a good blend of designing and it would be great for both of us as i can work for you at low cost

$300 USD in 10 days
(5 Reviews)

Hi , We are interested , Please check PMB...

$850 USD in 10 days
(1 Review)

Please check PM for further details.

$750 USD in 45 days
(0 Reviews)

hi, i will design nad develop your alumni website. plz check the pmb reagrds karan

$700 USD in 25 days
(0 Reviews)

I am goiong to send you more details in your PM Box.

$750 USD in 15 days
(0 Reviews)

check pm. thanks

$750 USD in 30 days
(1 Review)

Hi we are interested to work with this project. Please check PM for more details.

$700 USD in 25 days
(0 Reviews)

plz check your pm box, thanks

$700 USD in 25 days
(0 Reviews)

USA Grade Beef!

$1500 USD in 17 days
(0 Reviews)

Sir/Madam, I've an efficient team of writers. We'll provide quality work free of plagarism. regards.

$250 USD in 1 day
(0 Reviews)

******************************************************************.. YOUR SEARCH ENDS HERE .. ******************************************************************* GET IT DONE RIGHT THE FIRST TIME! Hello, I look forward More

$699 USD in 8 days
(1 Review)

Please Check PMB.

$700 USD in 25 days
(0 Reviews)

I can build your Fraternity Alumni website within a week for $500. I'm a genuine freelancer from Britain looking to build my portfolio. You can see my skills and portfolio at

$500 USD in 7 days
(0 Reviews)