What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Widget that calculates road miles distance (based on google driving API)Asked by sharpie on August 16, 2014 at 07:44 AM
I wondered if there was a widget that calculated road miles distance (based on google driving API), for the UK, where the start point could be fixed so the user filling in the form only had to enter their location postcode or other venue. (Entertainment supplier travelling from base to event)
This could then be used to calculate a price based on amount/mile or amount/10miles etc excluding a base amount (typically 50 miles). So for example if the distance from fixed start point A to destination B is 150 miles and the cost per mile was 10p, the calculation would be 150-50=100*.10 which £10. Except the calculation, result and how it's arrived at isn't disclosed but can be added to another option further down to become part of a final price.
Unfortunately, we do not have a direct feature that would accomplish this one. But a workaround can be done, using our widgets.
1. Use Driving Distance Widget: http://widgets.jotform.com/widget/driving_distance. You have to type the complete address to "FROM" and "TO" section. You'll get the result in Miles or Kilometer:
2. Use our Calculation Widget to calculate the total cost: https://www.jotform.com/help/259-How-to-perform-calculation-in-the-form.
I can create an example form for you, but I need to clarify the values:
10p is what?
50 is fixed deduction per total miles?
.10 is what? You mean, this is Euro?
By the way, to calculate the total cost, you need to add a textbox that would allow clients to put the Total Distance in Miles per the Driving Distance widget result. Here's a propose form:
Sadly that isn't what I'm looking for, it's absolutely essential that in now way does the client see that distance is a contributing factor to any price given as they progress through the form. The value is simply added, discreetly, to a main item further on.
So if this isn't available currently are there any developers who can. I've tried to search the web for jotform widget developers but sadly doesn't return any.
We can submit a request to our higher team support and possibly to our dev team about this feature that you need.
But I suggest you provide more clarity first to what exactly is your requirement.
The first step you can do is to create the form. A basic layout of the form on how you imagine it should work will help us understand clearly how to go about creating your form.
If you can share to us a similar concept either on other website or in JotForm, it will also help.
For example, I imagine your requirement have similar concept to this JotForm calculation template
this Fuel Cost Calculator form calculates fuel cost -- but in your requirement it was the price for distance cost.
During my research for this, there has clearly been many frustrated searchers looking for an automated system to issue prices based on a range of options and indeed several wanted to include some element of 'driving mile' costs based on driving distance not as the crow flies, as an instant quote. So I imagine it would be popular.
On further investigation this morning, I don't think jotform can do what I'm looking for, ignoring the travel price calculator. It would need to be able to assign a monetary value in any field option on the form (if required) and add these to a total figure at the bottom. On checking the only way to achieve this is using one of the payment gateways, but this is just a 'quote' not an order confirmation, so doesn't require a payment mechanism just the ability to present a final total and submit copy to us and to them. Along the lines of this package here http://www.quickquotewizard.com/ which doesn't look very well supported.
I appreciate this may not be possible but being able to show 'minimum prices' based on a calculation may just remove those enquiring who have no where near the budget or price expectation. i.e. if our min price is £50 and they think it's only going to be £20... the problem I have is I may be able to do a local event at £50 but the same product delivered 150 miles away may be nearer £90 - clearly a huge difference.
Assuming it's possible to 'rejig' all the fields in Jotform (which I doubt, to assign a monetary value where needed). Two elements within our quote are essential, the base product and the travelling, in my example there are 2 base products 'Product A' and 'Product B' any other products that appear on the form would be optional but one of these two must be selected.
How would widget work?:
Input Field = Destination postcode.
Widget Wizard allows input of fixed start postcode, adjustment of max miles allowed before cost added and cost per mile. So if we set max free travel is 50, travel cost is .10p per mile, venue is 150 miles away, we need to add on 100 miles of travel cost which in GBP is £10. These could be altered as required.
So in our example it would update Product A to read £60.00 and Product B to read £110, except the user wouldn't see this until they have completed page 1 - where they input postcode, so they don't see this element of the calculation. They simply get a starting price before adding options on.
Quick rough form http://www.jotform.com//?formID=42282070147347
Hopefully this helps explain.
I still believe that the calculation and quotation you want to have on the form is very much possible using JotForm.
I checked your form http://www.jotformeu.com/form/42282070147347 but it just lacks the calculation details that we would have wanted to understand.
Can you provide a clear calculation matrix? You can post it here.
Example, I am looking for something like this
Base Amount = 100p /50miles
Price A = amount/mile
Price B = amount/10miles
A = Distance(mile) * Price A
B = Distance(mile) * Price B
C = Base Amount + A or Base Amount + B
Check also this user guide
In the user guide, it was described how to have a "Quotation form" without any Payment tools and then the capability to pass the quotation value to an actual payment process(2nd form).
OK all sounds good
(Input price per mile) (Input Free Distance)
A: Distance - B: Free Distance * C: Price per mile = Sum
A-B*C=Sum i.e. (A: 150-B: 50*C: .10=Sum £10) or (A: 150-B: 25*C: .45=Sum £56.25)
Product A + Sum = Base Price
Product B + Sum = Base Price
and so on for however many 'required' starter products but customers will only be able to choose one.
Does that help?
This certainly help. Please allow us some time to create a concept form.
We will get back to you when we have a demo form you can check.
I've since been informed by TitusN that he has a distance planner widget with some of the functionality and is looking to see if it can be updated?
This thread can be seen in the forum section.
I am not really which widget was mentioned. But if you search JotForm Widgets, the only 'distance' related that matches what you need was actually the one mentioned by our colleague Welvin on his original response on this thread.
I was referring to the Driving Distance Widget.
Perhaps TitusN meant that they were planning to update the driving distance widget to have functionality similar to your requirement. TitusN is part of the widgets dev team, it will be much better indeed if a Widget can be created for such particular application.
We can wait also for that widget to come around. I will also seek details from TitusN about this details.
This thread can be seen in the forum section
Are you asking if this thread can be seen on the public forum? Yes it is.
I've had a thought, if it's at all possible on a way to make the widget even more universal for others and to perform another task we have planned in future development.
The ability to offer the user option to select nearest office from a list - this would then be the starting point. in our instance this would be to select the nearest service engineer - and minimise ridiculous quotes from those living in completely the opposite end of the country who may have to drive 3-400 miles to attend.
Clearly each engineer base would need to be programmed in as a town or postcode.
Just a thought?
Yes - the idea is certainly reasonable.
Perhaps a drop-down list of options to the nearest location the user can select from.
We will look into implementing this, but it might take some time.
We do appreciate your patience.