Dynamic calculation of price based on the calculated distance
Requirement
Calculate the cost of a taxi or hired car based on distance.
Use Case
A cab booking application calculates and displays the approximate cost of a trip based on pickup and drop-off addresses, after which the user can choose to book the ride in the
Rent Requisition
form
by clicking a button.
Steps to follow
Form | Form Link Name | Field Type | Field Name | Field Link Name |
Rent Requisition | Rent_Requisition | Name | Name | Name |
Phone | Phone | Phone_Number | ||
Date-Time | Travel Date & Time | Travel_Date_Time | ||
Single Line | Starting Point | Starting_Point | ||
Single Line | Drop | Drop | ||
Booking | Booking | Single Line | Starting Point | Starting_Point |
Single Line | Drop | Drop | ||
Decimal | Distance | Distance | ||
Currency | Price | Price |
2. Duplicate the
Booking
form to create a
stateless form. Rename it
Booking Estimate. We are using a stateless form because we are just using it to display the estimate. Some customers may just browse or check for the price.
3. Click on the
Form Properties
icon in the form builder header of the
Booking Estimate
form.
4. In the slider, remove the default buttons:
Submit
and
Reset.
5. Create a button by clicking
Add Button.
6. A new button named
Button
is created. Rename it to
Book Now!
as shown below, by clicking the three dots to the right of the button name.
7. In the same way, create a button named
Calculate Price.
8. Create a workflow
on the
Booking Estimate
form, to be executed upon loading the form, to disable the
Price
and
Distance
fields.
9. Click
Add New Action. Add the below code to disable the
Price
field:
- disable Price;
- disable Distance;
10. To calculate an estimate for the trip based on the distance traveled, create another workflow to execute when the
Calculate Price
button is clicked.
11. Click
Add New Action
and add the below code to calculate
Distance
and
Price. We are using the Zoho Maps Deluge method to find the
distance between
two locations.
- //Calculate the distance between Start and Drop in km. We are using trim() to remove any spaces in the Starting Point and Drop
- dist = round(zoho.map.distanceBetween(input.Starting_Point.trim(),input.Drop.trim(),"KILOMETRE"), 2);
- //Assuming driver cost to be Rs.350
- driverCost = 350;
- //Assuming the driving cost to be Rs.17/km
- ratePKm = 17;
- //Calculating the prime estimate
- price = round(driverCost + (dist * ratePKm) , 2);
- //Since clicking the button refreshes the form, we are reopening the form after calculation¯with the values.
- openUrl("#Form:Booking_Estimate?Starting_Point=" + input.Starting_Point + "&Drop=" + input.Drop + "&Distance=" + dist + "&Price=" + price , "same window");
This will display the estimate of the cost of the journey.
12. Create a workflow for booking the cab when the
Book Now!
button is clicked after the estimate is shown.
13. Click
Add New Action
and click
Deluge Script. Add the below script to open the
Rent Requisition
form with the
Starting_Point
and
Drop
fields already populated.
- openUrl("#Form:Rent_Requisition?Starting_Point=" + Starting_Point + "&Drop=" + Drop, "same window");
The customer will enter the
Travel Date & Time
and rider details.
See how it works
Points to Note
-
The distance-between method can be used on two address fields with the following Deluge code:
- zoho.map.distanceBetween(Starting_Point, Drop, "KILOMETRE");
Related Links
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Rent calculation based on multiple values selected by customers for events
Requirement Estimate rent for a property based on the date and time it is booked, as well as attendance numbers. Use Case A party hall of a hotel is being rented out. Here is the pricing structure of the hall: Day Base price (in USD) Standard guests ...FAQ: Stateless Form
This page covers essential insights on Zoho Creator, including stateless form creation, optimized workflows linked to submissions, and the seamless process of creating forms without reports. What are stateless forms in Zoho Creator? Stateless forms ...Prefill content in a form based on another form
Requirement When one form is submitted with data, users are redirected to another form with pre-filled data from the previous form. Use Case An order management app contains two forms: one to store suppliers' details, and the other to store the ...Appointment Management with Dynamic Drop Down
Requirement Allow patients to book appointments with their doctors. Use Case A clinic wants to digitize its booking system. There are multiple specialists and different dates/times for appointments. Each appointment lasts for 30 minutes. There ...Update an existing record using stateless forms
Requirement Use details specified in a stateless form to modify records in the main form. Use Case In an order management system, a customer has placed an order and wants to cancel it. The administrators allow for cancellation by accepting the ...
New to Zoho LandingPage?
Zoho LandingPage Resources