www.webdeveloper.com
Results 1 to 4 of 4

Thread: Quote/Price widget/script calculated from inputs on a form

Hybrid View

  1. #1
    Join Date
    Jun 2013
    Posts
    2

    Quote/Price widget/script calculated from inputs on a form

    I need help to develop a script/widget that will produce a quote/price based on the response to the questions on this form https://docs.google.com/forms/d/1Z2e...it?usp=sharing

    Base rate - 4.00%

    Discounts on base rate for the following fields:
    Type of cover - If option selected is Comprehensive minus 0% from base rate
    If option selected is Third Party Fire & Theft minus 20% from base rate
    If option selected is Third Party only minus 70% from base rate

    Tracking device - If option selected is Yes minus 15% from base rate
    If option selectd is No minus 0% from base rate

    Loadings on base for the following fields:
    Vehicle value - If the vehicle value inserted > R150 000 add 0% to base rate
    If the vehicle value inserted < R150 000 add 50% to base rate
    Vehicle use - If the option selected is Private... add 0% to base rate
    If the option selected is Professional.. add 5% to base rate
    If the option selected is Business... add 15% to base rate
    Date of birth - If age is < 25 years add 30% to base rate
    If age is > 25 years add 0% to base rate
    Date license first obtained - if date is > 2 years from current date add 0% to base rate
    If date is < 2 years from current date add 30% to base rate
    Claims in last 3 years - if response is no claims add 0% to base rate
    if response is 1 to 2 claims add 5% to base rate
    if response is 2+ claims add 15% to base rate
    The total price must then be calculated by the cumulative sum of the above rating criteria expressed as a rate percent and applied to the Vehicle value
    Finally the following must be added in:
    Car Hire Cover - If response is yes add R60.00
    If response is No add NIL
    I hope someone out there can assist.
    Thanks & regards, Melvin

  2. #2
    Join Date
    May 2006
    Location
    Somewhere behind your screen
    Posts
    1,648
    you need help or somebody to develop this instead of you?
    xxx: Guess Buddhist riddle: "What is the sound of one hand clapping?"
    yyy: facepalm

  3. #3
    Join Date
    Jun 2013
    Posts
    2
    Yes I definitely need help as I do not have a clue about script writing. Will you be able to assist?
    Regards,

  4. #4
    Join Date
    May 2006
    Location
    Somewhere behind your screen
    Posts
    1,648
    i wish i could but i can't find a volunteer who will do my own work...
    xxx: Guess Buddhist riddle: "What is the sound of one hand clapping?"
    yyy: facepalm

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles