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.
NEED TO ADD
A sortable database of members information -
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 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
ADD THESE CAPABILITIES
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]
15 freelancers are bidding on average $702 for this job
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
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 benbowler.com.