Calculate the price with Tax included based on days and options selected

What is JotForm?

JotForm is a freeonline form builder which helps you create online forms without writing a single line of code.

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.

Why do you not want to answer this thread?(Your answer will be sent to Jeanette and Aytekin)

KittySmack

Asked on October 06, 2014 at 12:30 PM

We are using this as a hotel reservation form. That being said, I need the ability to have the room rate change based on the day of the week.

For example,

If it is Sunday - Wednesday, the rates would be:

1 bedroom - $55.00

2 bedroom - $55.00

3 Bedroom - $95.00

Cottage - $135.00

If it is Thursday - Saturday, the rates would be:

1 bedroom - $95.00

2 bedroom - $95.00

3 Bedroom - $1355.00

Cottage - $175.00

Any help would be greatly appreciated.

In addition, ideally, I would love to have the ability to set rates and availability based on dates, up to two years in advance, be able to close room types if sold out, etc., but it seems that this would require a database. Along with the database, I would need a front end that I can update values based on single days, bulk updates based on from - to dates, or from - to dates based on the days of the week, for example, if the from - to dates are sept 1 - dec 31, I may only want to update thursday - saturday dates in this date range.

We like to keep one issue/question per thread so I have moved your last part of the message to another thread here http://www.jotform.com/answers/439224

What you would like to achieve with the date calculations can be done by duplicating the field that hold the prices and then show one or another based on the date.

If you tell us which jotform you would like to have this set it we can give you a more detailed explanation of what should be used.

Now in short as mentioned above would be do duplicate the field that has these prices and add a hidden date field that is pre-filled with current date. Then go into conditions and set it up so that it only shows one or the other depending on the exact day.

Now if you want to select the prices based on the day that your visitor has selected to rent it, then you do not need to have the hidden field and can just set the conditions to match the day selected and based on that show and hide the proper fields.

Again, I would suggest letting us know which jotform you would like to see this change in and based on that we would be able to give you more details on how to change and what to change.