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.
how to add a surcharge to certain datesAsked by daveprenter on April 28, 2014 at 06:13 AM
Hello there, seems like I am always asking you guys for help.
I have set up an accommodation booking type form and would like to add a surcharge for any nights that people stay during certain holiday periods. I know I need to set up a condition along the lines "If date guest is staying falls between x and y dates then z surcharge per night is applied. I have set up the check in date picker but I cant' work out a way to calculate the number of nights that fall within a set period. I don't think it is possible but thought I would ask anyway......
Thanking you for all your help so far.
I was able to come up with a solution to your problem but it will require some changes on your form. Rather than asking for how many nights they will stay, I created a form that asks for a checkout date and calculates the difference and makes the calculations based on that. That is needed for the calculations to work, I hope that's ok.
Here is the form:
Let me walk you through it real quick.
So the number of people, check-in and check-out dates are pretty straightforward.
"Number of nights" is a calculation widget:
Checkout - Checkin
And then there's two "total fee" fields. Both of them are calculation fields:
For normal rates:
Number of nights * Number of people * 2
For seasonal rates:
Number of nights * Number of people * 5
The seasonal rate field is hidden by default(right click on the field to do so)
Then I created a condition like so:
So basically, if the check-in date is between 15th and 30th of May, it will hide the normal rate field and show the seasonal rate field.
Hope this helps. Please let us know if there's anything else we can do for you.
Thanks & have a good day!
Edit: Just a small tip. You may wanna uncheck default time on the checkout field and check the "wait for input" setting in the "number of nights" calculation in order for the form to not show negative numbers.
Hi egeg ,
Thank you so much for spending the time to do this. I was thinking of a similar solution using a date string to calculate the check out date. However , it unfortunately doesn't work. If someone starts their stay outside the holiday period, but cross over into the holiday period then ALL nights will be calculated at the non holiday rate. Conversely , if people begin their stay during the holiday period but cross over into the non holiday period then ALL nights would be calculated at the holiday rate, even though the last nights of their stay were outside the holiday period.
That is the problem I can't find a way around.
Do you have any ideas maybe using date string or something?
Or is it possible to get a custom script without changing my present form too much/
If not then I will just work around it.
Please be noted that if you embed your form using its source code, any changes you make to your form in editor will not be reflected in your web page. You will have to download the form's source code and embed it again in your web page.
We will wait for your response.
Ok, well if that is the case I think it is easier just to work around it. I (believe it or not) would like to keep things as simple as possible. Thanks very much for your help anyway.