Web form with reporting dashboard - SQL Project


My Budget is $100. Not more than that! Working on milestones. Newlancers are encouraged to apply!! LOOKING FOR LONG TERM RELATIONSHIP

This is a no fail project with short deadline. If you do not have the ability to complete the job please do not bid!

This is a lead generation project with simple dashboard for consultants to login and review leads.

1. Form with basic contact fields, name, email, phone, 4 radio button options, check box for terms and condition, submit button.

Plus, a promo code field that is related to multiple features.

A. Visitor enters promo code in the form with the other information and they hit submit.

Function - Auto responder upon successful form submission. The auto responder from address would be variable so that it could be sent from the associated consultant.

Option: Ability to merge a field from the promo code database into the body of the auto responder email

Function - Promo Code is compared to promo code database and verified as valid.

If invalid return message to user that promo code is invalid - there are 2 types of invalid - code does not exist or code has been redeemed.

There are 2 types of promo codes - single use and 20 uses.

Function - Valid code - The database will have a consultant who is associated with a range of promo codes. When a valid promo code is entered then the associated consultant would receive a lead notification.

Function - Form data is added to a database and associated with the consultant that was associated with the valid promo code.


Consultants should be able to log into the dashboard and only see their leads but corporate should be able to login and see everyone's leads.

Features in dashboard:

Once logged into a consultant dashboard you should be able to see all your leads, sort them by column etc...

Be able to click on a lead and see only that lead where you could add notes, and have 4 check boxes that you can use to help segment your leads based on their status.

Check Box 1 - Appointment Made

Check Box 2 - Presentation Completed

Check Box 3 - Signed Up PC

Check Box 4 - Signed Up Consultant

Function - There is another check box labeled Automate Follow Up. If the consultant checks that box for that lead then that releases a series of 3 emails that are sent based on time after check box checked. 2 days 7 days 12 days.

Automated emails must merge the email from address from the database so that the email comes from the associated consultant.

Emails should have the ability to merge a field from the database. For example be personalized with the prospect / visitor name & a paragraph of copy about one of the check boxes that they checked when the completed the form and the email should be able to merge the associated consultant contact info.


Link that allows the prospect/visitor to click a link in the automated emails and say that they dont want to receive emails anymore and the dashboard be updated.

Optional Function:

Page / Tab in the dashboard that has training info, campaign images, etc... and the ability to merge a field from the database associated with them as they logged in.

Please ask any questions and I will clarify, ready to assign this job and get started with a professional that can deliver, not just say they can.

The attached pdf show all the functions. This was originally a zoho, caspio, or lianja project but you build however you want. Just be able to get it done.

Skills: Graphic Design, HTML, MySQL, PHP, Website Design

See more: zoho consultant, your email address is invalid, where can i get a graphic design job done, when to use merge sort, web page design with codes, web page design notes, web design paragraph, web design information in pdf, sql functions pdf, sql database consultant, sql consultants, sql code pdf, simple reporting, show all notification web page design, questions to ask it consultants, questions to ask a consultant, questions related to graphic design, questions a consultant should ask, php codes pdf, personalized graphic design, paragraph for web design contact, paragraph for web design, on the job training graphic design, my email address is invalid, lead generation pdf

Project ID: #5407597

8 freelancers are bidding on average $83 for this job


Hi! I am qualified and experience freelancer with 5* reputation. Please visit my profile to know about my clients satisfaction. I am ready to work. Let me know if you are interested. Thanks, Rajib

$100 USD in 7 days
(58 Reviews)

I have read your description for this Website carefully and really interested in taking up this project.I am a php | css | HTML5 | mysql | jQuery expert with rich experience. I have done many successful php | css | HTM More

$100 USD in 2 days
(3 Reviews)

I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. I have good level of experience in Core PHP , OpenCart , Magento, Wordpress, Drupal More

$70 USD in 2 days
(10 Reviews)

Hello, My name is Stanimir and work in the field of web development. I was born in Bulgaria. I work as a professional programmer than 5 years, and I think I can be useful in your task. For me, basic concepts and pr More

$111 USD in 3 days
(3 Reviews)

Hi, We have experience of more than 10 years in Web Development. We have also been involved in development of many Wordpress themes, joomla sites, ecommerce websites and portals.

$61 USD in 1 day
(1 Review)

Hi I Am Three Years Experience In PHP ,WORDPRESS ,CSS ,HTML5 ,JQUERY I Ensure That This Work Is Complete In Your Time Limitation Also Full Fill Your All Functionality Thanks Ashok

$100 USD in 4 days
(2 Reviews)

Hello sir i am Professional software engineer . i have done many php projects locally but i am new to freelancer so i will develop your project at a very low cost . you can check my cv. looking foreword to work with yo More

$60 USD in 5 days
(0 Reviews)

Предложение еще не подано

$61 USD in 3 days
(0 Reviews)

La propuesta todavía no ha sido proveída

$100 USD in 3 days
(0 Reviews)