web based calender/crm

Web based scheduler and CRM: I am developing a website using dolphin community that uses a sql database and has html capabilities. My site: [login to view URL] I need a web-based appointment calendar/ crm application that will appear on individual subscribers pages who have a particular subscription. It would be considered a module that I will add to qualifying subscribers. It should have following capabilities: • Visitor can request appointment on subscriber’s online calendar which shows date and time availability by services offered by subscriber. E.g. Hair stylist would be the subscriber and the calendar will show: o Tuesday, September 17, 2011 1:00-2:00 PM Service: Haircut o Tuesday, September 17, 2011 3:00-4:00 PM Service: Wash and Dry. o Visitor would see that September 17, 2011 5:00-6:00 PM is available. • Appointment Setting: Visitor can click on open date and time on the calendar and a form will appear that will have: o Option for new or existing client.  If existing client, visitor would input name and email address into the field • If New Client – Register Form with input for client info: First and Last Name, Email Address, Telephone number, Address, Birthday, services requested. • Form will appear that contains: o Drop down box of employees associated with that subscriber o Dropdown box of locations associated with the subscriber o Check box of services offered that allows for multiple selections o Date and Time selector o A Link to Service History- window with list of previous appointments and serviced provided. o Notes Box: to add notes • Visitor will select: employee, location, services, date and time, as well as, notes if any and submit. • Email notifications will be sent to both the subscriber and visitor. • Subscriber receives an email and (optional) text for an appointment request. The text would indicate that they had an appointment request and direct them to their page. The email will provide links for the following options: o Confirm- Automatically Confirm appointment o Refuse- Automatically deny o Contact- Automatically Call me o Account history: Link back to their administration page on website :  Administration page contains menu: • Calendar • Pending request o Confirm- Automatically Confirm appointment o Refuse- Automatically deny o Contact- Automatically Call me • Confirmed request o Cancel- Automatically Cancels o Contact- Automatically Call me • Refused Request • Client listing o Client Info o Client History  Services  Products  Notes System should • Receive Unlimited Online Appointments • Add Unlimited Staff and Services • 12-Month Advance Scheduling • View client and appointment history • Mobile iPhone Access • Email Confirmations are instantly sent to clients and employees • Email Reminders are sent to clients 24 hours before each appointment • Cancelled Appointment Emails are sent to assistants if an appointment is cancelled within a predefined period before the appointment date • Mobile Text Reminders send text reminders to employees and clients mobile phones • Appointment Comments enter a comment for each appointment • Waiting Lists clients get notified if an earlier time and/or date opens up • Export Client Profiles and Booked Appointments to Excel® provides an in depth view to all of your clients profile details • Birthdays send them promotions and warm greetings on their special day • Synchronize with Outlook® and Other Calendars you have multiple ways to sync up with other calendars • Appointment History see a complete list of appointments Example: [login to view URL]