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
you need help or somebody to develop this instead of you?
Yes I definitely need help as I do not have a clue about script writing. Will you be able to assist?
i wish i could but i can't find a volunteer who will do my own work...
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)