Calculate the price of the stay and how many are in the room

  • Profile Image
    trishf
    Asked on July 03, 2018 at 04: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?

  • Profile Image
    jonathan
    Answered on July 03, 2018 at 04:50 PM

    Yes this is very much possible using Calculations and Payment integration.

    You can test my demo form https://www.jotform.com/81836505878975

    1530650932zzz 2018-07-04 04.48.29.png


    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.


  • Profile Image
    trishf
    Answered on July 03, 2018 at 05:43 PM
    This 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.*
    ...
  • Profile Image
    Richie_P
    Answered on July 03, 2018 at 05: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.

  • Profile Image
    trishf
    Answered on July 05, 2018 at 08:43 AM
    The 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.*
    ...
  • Profile Image
    Richie_P
    Answered on July 05, 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.

  • Profile Image
    trishf
    Answered on July 05, 2018 at 03:43 PM
    HI,
    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.*
    ...
  • Profile Image
    jonathan
    Answered on July 05, 2018 at 04: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.


  • Profile Image
    trishf
    Answered on July 05, 2018 at 04:43 PM
    Yes, 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.*
    ...
  • Profile Image
    Richie_P
    Answered on July 05, 2018 at 05: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.

  • Profile Image
    trishf
    Answered on July 06, 2018 at 11:43 AM
    How 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.*
    ...
  • Profile Image
    aubreybourke
    Answered on July 06, 2018 at 01: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:

    1530897370u0uc9.png

    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:

    1530897548yi5us.png


    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


  • Profile Image
    trishf
    Answered on August 11, 2018 at 11:43 AM
    How 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.*
    ...
  • Profile Image
    trishf
    Answered on August 11, 2018 at 12:43 PM
    I 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.*
    ...
  • Profile Image
    Mike_G
    Answered on August 11, 2018 at 02: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