Can the form calculate cost based on number of days of booking?

Hello,

I am wanting to create a form where customers can hire out products. These products have a daily hire price, so I want the form to calculate the cost based on product selected and how many days they want the product for. Is this possible with Jotform?

Thanks for your help.

Naomi

Yes that is possible. Kindly use regular fields to list out your products, then set the rental price as a calculation value.

How-to-Assign-Calculation-Value

Then add a Form Calculation widget to calculate the total based on the product selected and the number of days supplied.

How-to-Perform-Form-Calculation-Using-a-Widget

Once done, you can then pass the calculated data to your payment field.

How-to-Pass-a-Calculation-to-a-Payment-Field

Thank you very much for your response.

Can I do this with the booking app or date reservation widget?

Thanks!

Naomi

Since you need a start and end date, may I suggest to use the Dates Difference widget instead so that the number of days is automatically calculated and can then be used on the Form Calculation widget.

Thanks for your reply
Does the date Difference widget work on a calendar, so I don't get double
booked?
Naomi
...

Unfortunately, no, the Date Difference does not block off a calendar date.

Can you please share the URL of the form you are working with and please explain in detail the entirety of your form's workflow so that we can properly provide a suggestion?

Where-to-Find-My-Form-URL

HI,

Thank you for your help with this

the url is https://www.jotform.com/build/202891940479870

I have 3 items I want to hire out on a daily basis. The items can be booked for multiple days

Each item has a different price and can only be booked once a day, so it needs to be linked to a calendar.

We require payment at the time of booking

Kind regards,

Naomi Taylor

You can limit the product options by using any of the widgets below:

Inventory widget: https://www.jotform.com/widgets/inventory the widget will ensure that each time your form is submitted, the total amount purchased or ordered at the time is deducted from the inventory.

Quantity Gift Registry: https://www.jotform.com/widgets/quantity-gift-registry When the items on your list have run out, the widget will cross out the item as unavailable.

Ticket Purchases: https://www.jotform.com/widgets/ticket-purchases This widget is a checklist of different types of tickets, with a counter that tells your form users how many tickets are available before they get sold out.

You need to collect the product orders outside the payment field possibly using any of the widgets above and then pass the calculation to the payment field to collect payment.

Could you explain your requirement further.

Looking forward to your response.

Thank you.

Hi
I only have one of each item.
But I need them to connect to a calendar so that I know which days it is
booked, and they don't get double booked.
Thanks for your help.
...

Unfortunately, there is no other way to connect the dates with the products and limit the products to 1 each day.

In those widgets, you can set the limits each day so that you do not get any double bookings for that day.

Let us know if you have further questions.

Thanks.

Thank you for your reply.
How do I connect the widget so that it will calculate the payment amount?
Naomi
...

I think what you want can be done using the Appointment field. Please allow me some time to create a demo form for you. Will get back to you afterwards.

PGRpdiBkaXI9J2F1dG8nPlRoYW5rcyE8L2Rpdj48ZGl2IGNsYXNzPSJnbWFpbF9leHRyYSI+PGJy
PjxkaXYgY2xhc3M9ImdtYWlsX3F1b3RlIj5PbiAyMCBPY3QgMjAyMCAyOjAxIHBtLCBKb3RGb3Jt
ICZsdDtub3JlcGx5QGpvdGZvcm0uY29tJmd0OyB3cm90ZTo8YnIgdHlwZT0iYXR0cmlidXRpb24i
IC8+PGJsb2NrcXVvdGUgY2xhc3M9InF1b3RlIiBzdHlsZT0ibWFyZ2luOjAgMCAwIC44ZXg7Ym9y
ZGVyLWxlZnQ6MXB4ICNjY2Mgc29saWQ7cGFkZGluZy1sZWZ0OjFleCI+IA0KPGRpdj4NCiAgICAg
ICAgPGRpdiBzdHlsZT0iaGVpZ2h0OjEwMCU7d2lkdGg6MTAwJTtiYWNrZ3JvdW5kOiNlZWVlZWU7
bWluLWhlaWdodDozMDBweDtkaXNwbGF5OmlubGluZS1ibG9jaztmb250LWZhbWlseTomIzM5O2x1
Y2lkYSBncmFuZGUmIzM5OyAsICYjMzk7YXJpYWwmIzM5OyI+DQogICAgICAgICAgICA8ZGl2IHN0
eWxlPSJtYXJnaW46NTBweCBhdXRvO2JvcmRlcjoxcHggc29saWQgI2RkZGRkZDtiYWNrZ3JvdW5k
OiNmZmY7d2lkdGg6NTAlO21pbi13aWR0aDo1MDBweCI+DQogICAgICAgICAgICAgICAgPGRpdiBz
dHlsZT0iYmFja2dyb3VuZDpub25lIHJlcGVhdCBzY3JvbGwgMCAwICM0NTQ1NDU7Zm9udC1zaXpl
OjE0cHg7Y29sb3I6I2ZmZmZmZjtoZWlnaHQ6MzRweDtwYWRkaW5nOjhweCAxMnB4Ij4NCiAgICAg
ICAgICAgICAgICAgICAgPGRpdiBzdHlsZT0icGFkZGluZzo4cHg7ZmxvYXQ6bGVmdCI+DQogICAg
ICAgICAgICAgICAgICAgICAgICBBIG5ldyByZXNwb25zZSBoYXMgYmVlbiByZWNlaXZlZDoNCiAg
ICAgICAgICAgICAgICAgICAgPC9kaXY+DQogICAgICAgICAgICAgICAgICAgIDxhIGhyZWY9Ii8v
d3d3LmpvdGZvcm0uY29tIj48aW1nIHNyYz0iaHR0cHM6Ly93d3cuam90Zm9ybS5jb20vaW1hZ2Vz
L2xvZ28yLnBuZz8yIiBhbHQ9IkpPVEZPUk0iIGhlaWdodD0iMzYiIGFsaWduPSJyaWdodCIgYm9y
ZGVyPSIwIiAvPjwvYT4NCiAgICAgICAgICAgICAgICA8L2Rpdj4NCiAgICAgICAgICAgICAgICA8
ZGl2IHN0eWxlPSJwYWRkaW5nOjIwcHgiPg0KICAgICAgICAgICAgICAgICAgICA8ZGl2IHN0eWxl
PSJkaXNwbGF5OmlubGluZS1ibG9jazt3aWR0aDoxMDAlO21pbi1oZWlnaHQ6MzAwcHgiPg0KICAg
ICAgICAgICAgICAgICAgICAgICAgPGRpdiBzdHlsZT0iY29sb3I6Z3JheTtmb250LXNpemU6MTJw
eDttYXJnaW4tYm90dG9tOjEwcHgiPg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgIEFuc3dl
cmVkIGJ5DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgPHN0cm9uZz4NCiAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgVmFuZXNzYV9UICAgICAgICAgICAgICAgICAgICAgICAgICAg
IDwvc3Ryb25nPg0KICAgICAgICAgICAgICAgICAgICAgICAgPC9kaXY+DQogICAgICAgICAgICAg
ICAgICAgICAgICA8cCBzdHlsZT0ibWFyZ2luOjEwcHg7d2lkdGg6MTAwJTttYXgtd2lkdGg6MTAw
JSI+DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgPC9wPjxwPkkgdGhpbmsgd2hhdCB5b3Ug
d2FudCBjYW4gYmUgZG9uZSB1c2luZyB0aGUNCkFwcG9pbnRtZW50IGZpZWxkLiBQbGVhc2UgYWxs
b3cgbWUgc29tZSB0aW1lIHRvIGNyZWF0ZSBhIGRlbW8gZm9ybSBmb3IgeW91LiBXaWxsDQpnZXQg
YmFjayB0byB5b3UgYWZ0ZXJ3YXJkcy48L3A+ICAgICAgICAgICAgICAgICAgICAgICAgDQogICAg
ICAgICAgICAgICAgICAgIDwvZGl2Pg0KICAgICAgICAgICAgICAgIDwvZGl2Pg0KICAgICAgICAg
ICAgICAgIDxkaXYgc3R5bGU9ImJhY2tncm91bmQ6IzQ1NDU0NTtmb250LXNpemU6MTJweDtwYWRk
aW5nOjZweCAxMHB4O2hlaWdodDoyMHB4O2xpbmUtaGVpZ2h0OjE4cHgiPg0KICAgICAgICAgICAg
ICAgICAgICA8YSBocmVmPSJodHRwOi8vd3d3LmpvdGZvcm0uY29tL2Fuc3dlcnMvMjYzNzI0My1D
YW4tdGhlLWZvcm0tY2FsY3VsYXRlLWNvc3QtYmFzZWQtb24tbnVtYmVyLW9mLWRheXMtb2YtYm9v
a2luZyIgc3R5bGU9ImNvbG9yOiNmZmZmZmY7ZmxvYXQ6cmlnaHQiPlZpZXcgdGhpcyB0aHJlYWQg
b24gYnJvd3NlciDCuzwvYT4NCiAgICAgICAgICAgICAgICAgICAgPGEgaHJlZj0iaHR0cDovL3d3
dy5qb3Rmb3JtLmNvbS9hbnN3ZXJzLzI2MzcyNDMtQ2FuLXRoZS1mb3JtLWNhbGN1bGF0ZS1jb3N0
LWJhc2VkLW9uLW51bWJlci1vZi1kYXlzLW9mLWJvb2tpbmc/ayYjNjE7MjY5NzZjZmY2NDk2NzIy
NmYwZjkwZTM3Njc3NjE4ZGMmYW1wO3Vuc3Vic2NyaWJlJiM2MTsiIHN0eWxlPSJjb2xvcjojY2Nj
Y2NjO2Zsb2F0OmxlZnQiPlVuc3Vic2NyaWJlIFRocmVhZDwvYT4NCiAgICAgICAgICAgICAgICA8
L2Rpdj4NCiAgICAgICAgICAgIDwvZGl2Pg0KICAgICAgICAgICAgPGxhYmVsIHN0eWxlPSJjb2xv
cjojZWVlZWVlIj4xNjAzMTczNjYwPC9sYWJlbD4NCiAgICAgICAgPC9kaXY+DQogICAgPC9kaXY+
DQoNCjwvYmxvY2txdW90ZT48L2Rpdj48YnI+PC9kaXY+
...

My apologies, after several attempts, unfortunately, I am unable to find a solution that fits everything that you need.

1. We have options to block off dates using Appointment field and Date Reservation widget.
2. We also have ways to calculate the number of days based on selected date fields using Date Difference widget, Form Calculation widget or conditions, but none of them can block off dates.

Let us know if you are fine with having only the option 2 so we can provide you the steps.

Thanks for trying Vanessa, I will keep looking for a solution elsewhere.
...