-
trishfAsked on July 3, 2018 at 4:24 PM
Hi,
I'm putting together a Hotel Booking Form. Is there a way to calculate the price of the stay by using their dates and how many are in the room?
-
jonathanReplied on July 3, 2018 at 4:50 PM
Yes this is very much possible using Calculations and Payment integration.
You can test my demo form https://www.jotform.com/81836505878975
For the Check-In/Out date field, I suggest using the Date Picker field instead (2 of them) to be able to do calculations using date fields.
Let us know if you need further assistance.
-
trishfReplied on July 3, 2018 at 5:43 PMThis is awesome!! I'm going to need assistance setting this up. Can you
either call me or can I call you?
*Cheers!Trish Fleig, CTC & MCC*
*L'Attitudes Travel*
*Dayton, OH937-340-5300 <9373405300>*
*937-660-6911 Faxwww.lattitudestravel.com
*
*Like us on Facebook!Facebook.com/lattitudestravel
*
*FOR AFTER HOURS EMERGENCY ASSISTANCE*
*PLEASE CALL 888-425-7174 OR COLLECT 416-928-5436
PLEASE REFER TO SOS CODE-MSNAAG3106*
*Note: There is a $40 charge per call for all calls to this number.*
... -
Richie JotForm SupportReplied on July 3, 2018 at 5:59 PM
Unfortunately, we do not have phone support. However, we would gladly assist you via this thread.
In your Room Type dropdown, you can enable calculation values
so that you can assign a value depending on the room.
And as what my colleague has suggested on Check-In/Out date field, to use the Date Picker field instead (2 of them) to be able to do calculations using date fields.
Let us know how it goes.
Thank you.
-
trishfReplied on July 5, 2018 at 8:43 AMThe nightly total per room depends on how many guests per room. Is there
a way to incorporate this?
*Cheers!Trish Fleig, CTC & MCC*
*L'Attitudes Travel*
*Dayton, OH937-340-5300 <9373405300>*
*937-660-6911 Faxwww.lattitudestravel.com
*
*Like us on Facebook!Facebook.com/lattitudestravel
*
*FOR AFTER HOURS EMERGENCY ASSISTANCE*
*PLEASE CALL 888-425-7174 OR COLLECT 416-928-5436
PLEASE REFER TO SOS CODE-MSNAAG3106*
*Note: There is a $40 charge per call for all calls to this number.*
... -
Richie JotForm SupportReplied on July 5, 2018 at 10:18 AM
I have checked your form and you have not added any value to your current dropdown field for room type.
First, you must input a corresponding value to your room type.
Then use a Form Calculation, to calculate the number of guest x by the room rates.
Hope this information helps.
Here is my sample cloned form https://form.jotform.com/81854361642964
You could also clone the form to test it out -https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL
Please test the form and let us know it goes.
Thank you.
-
trishfReplied on July 5, 2018 at 3:43 PMHI,
I still can't get this to work correctly. One of the issues is if there
are two people in a room it a different cost if it is one person in the
room. Example: Mirage Club 1-Bedroom Suite w/ Jacuzzi .... Single rate
is 1586.60 / double rate is 1202.60 per person.
Second issue is the calculation is adding an extra number. When
calculating.
*Cheers!Trish Fleig, CTC & MCC*
*L'Attitudes Travel*
*Dayton, OH937-340-5300 <9373405300>*
*937-660-6911 Faxwww.lattitudestravel.com
*
*Like us on Facebook!Facebook.com/lattitudestravel
*
*FOR AFTER HOURS EMERGENCY ASSISTANCE*
*PLEASE CALL 888-425-7174 OR COLLECT 416-928-5436
PLEASE REFER TO SOS CODE-MSNAAG3106*
*Note: There is a $40 charge per call for all calls to this number.*
... -
jonathanReplied on July 5, 2018 at 4:01 PM
Example: Mirage Club 1-Bedroom Suite w/ Jacuzzi .... Single rate is 1586.60 / double rate is 1202.60 per person.
So what you are saying is, there is a discount rate (or less payment) if there is more than one person book in the room. Can you please elaborate more
Please layout the calculation here (when you reply again) so we can help you come up with the formula.
Right now the formula is just straight forward :
Total = Room Type * Number of Guest
We will wait for your response.
-
trishfReplied on July 5, 2018 at 4:43 PMYes, I think you have it.
Mirage Club 1-bedroom Suite w/ Jacuzzi ~ single rates $1586.60 / double
$1202.60 per person
Mirage Club Sky Suite w/ roof top Jacuzzi ~ single rate $1634.60 / double
$1256.60 per person
Mirage Club Swim up Suite w/ Jacuzzi ~ single rate $1826.60 / double
$1382.60 per person
Mirage Club Ocean View Suite w/ Outdoor Jacuzzi ~ single rate $1928.60 /
double $1448.60 per person
I also need for the form to calculate the deposit (amount due at time of
booking) which is $100 per person. That is the amount that needs to be in
the payment widget (I'll be using PayPal).
*Cheers!Trish Fleig, CTC & MCC*
*L'Attitudes Travel*
*Dayton, OH937-340-5300 <9373405300>*
*937-660-6911 Faxwww.lattitudestravel.com
*
*Like us on Facebook!Facebook.com/lattitudestravel
*
*FOR AFTER HOURS EMERGENCY ASSISTANCE*
*PLEASE CALL 888-425-7174 OR COLLECT 416-928-5436
PLEASE REFER TO SOS CODE-MSNAAG3106*
*Note: There is a $40 charge per call for all calls to this number.*
... -
Richie JotForm SupportReplied on July 5, 2018 at 5:06 PM
If you want to calculate the payment manually, you can change the Payment type to "user defined amount" in Paypal Settings.
Then pass the calculation to PayPal.
Here is a guide: https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field
Hope this information helps.
Please let us know if you need further assistance.
Thank you.
-
trishfReplied on July 6, 2018 at 11:43 AMHow do I configure for this????
*Cheers!Trish Fleig, CTC & MCC*
*L'Attitudes Travel*
*Dayton, OH937-340-5300 <9373405300>*
*937-660-6911 Faxwww.lattitudestravel.com
*
*Like us on Facebook!Facebook.com/lattitudestravel
*
*FOR AFTER HOURS EMERGENCY ASSISTANCE*
*PLEASE CALL 888-425-7174 OR COLLECT 416-928-5436
PLEASE REFER TO SOS CODE-MSNAAG3106*
*Note: There is a $40 charge per call for all calls to this number.*
... -
aubreybourkeReplied on July 6, 2018 at 1:21 PM
First I moved the number of guests up to the top. When you select 1 guest it shows a single room dropdown (with the single prices). If you select greater than or equal to two guests it show the double room dropdown (with the double prices)
The condition looks like this:
The check in/check out widget doesn't seem to be working for me. So I used the dates difference widget instead. The days field shows the number of selected days. You could hide this field if you don't want it to be visible on the published form.
Finally, the calculation looks like this:
Here's a working demo:
https://form.jotform.com/81865195474974
You can clone this if you like:
How-to-Clone-an-Existing-Form-from-a-URL
-
trishfReplied on August 11, 2018 at 11:43 AMHow do I make the calculations on the pricing work properly?
*Cheers!Trish Fleig, CTC & MCC*
*L'Attitudes Travel*
*Dayton, OH937-340-5300 <9373405300>*
*937-660-6911 Faxwww.lattitudestravel.com
*
*Like us on Facebook!Facebook.com/lattitudestravel
*
*FOR AFTER HOURS EMERGENCY ASSISTANCE*
*PLEASE CALL 888-425-7174 OR COLLECT 416-928-5436
PLEASE REFER TO SOS CODE-MSNAAG3106*
*Note: There is a $40 charge per call for all calls to this number.*
... -
trishfReplied on August 11, 2018 at 12:43 PMI got the calculations to work.Is there a way to collect credit card information without charging the card?
*Cheers!Trish Fleig, CTC & MCC*
*L'Attitudes Travel*
*Dayton, OH937-340-5300 <9373405300>*
*937-660-6911 Faxwww.lattitudestravel.com
*
*Like us on Facebook!Facebook.com/lattitudestravel
*
*FOR AFTER HOURS EMERGENCY ASSISTANCE*
*PLEASE CALL 888-425-7174 OR COLLECT 416-928-5436
PLEASE REFER TO SOS CODE-MSNAAG3106*
*Note: There is a $40 charge per call for all calls to this number.*
... -
Mike_G JotForm SupportReplied on August 11, 2018 at 2:46 PM
Considering your new concern is about another topic, I have moved it to a new thread.
Here's the link — https://www.jotform.com/answers/1550781