How can I change the price to correspond to the selected date?

  • rentacarokinawa
    2023年11月7日 18:36に質問

    現在、レンタカー予約でStripeと連動し利用しているフォームで、
    レンタル日によって価格を変動するニーズが生まれています。
    今までは、それぞれに対しフォームを作成しお客様に送る手法をとっていましたが、
    レンタル日ごとに価格がかわるものには対応が現実的ではなく
    解決できる方法がないか、模索しています。
    こちら至急対応が必要なため具体的に方法を教えていただけると助かります。

    どうぞ宜しくお願いします。



  • Mightor Jotform Support
    2023年11月7日 22:12に返信

    Hi rentacarokinawa, 

    Thanks for reaching out to Jotform Support. Unfortunately, our Japanese Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Japanese, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, let me help you with your question. I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

    Let us know if you have any other questions.

  • rentacarokinawa
    2023年11月7日 22:43に返信

    Dear Sir

    i translated message by GPT
    Please check and back ASAP will be so helpfull.


    Currently, in our car rental reservation form integrated with Stripe, there is a need to have variable pricing based on the rental date. Until now, we have been creating separate forms for each instance and sending them to customers, but this approach is not practical for situations where prices change with each rental date. We are searching for a solution and would greatly appreciate specific advice on how to resolve this issue.

    We need to address this urgently, so your prompt assistance would be highly appreciated.

    Thank you very much.

  • Mightor Jotform Support
    2023年11月7日 23:27に返信

    Hi rentacarokinawa, 

    Thanks for your patience, we appreciate it. Check the steps and screenshots below on how to change the price depending on the selected date:

    1. Add a hidden Multiple Choice field per set of prices. Then turn-on Calculation Values and put in the monetary values of the choices.

    2. Add a hidden Form Calculation widget, which will show the Total amount the user needs to pay. This field will also be used to integrate with Stripe.

    How can I change the price to correspond to the selected date? Image 1 Screenshot 60

    3. Then create a Show/Hide Field condition like the below screenshot. This will be used to show or hide the hidden Multiple Choice field, which has the pricing set.

    How can I change the price to correspond to the selected date? Image 2 Screenshot 71

    4. Create an Update/Calculate Field condition as see on the screenshot below. This will be used to calculate the total fees.

    How can I change the price to correspond to the selected date? Image 3 Screenshot 82

    As you can see on steps 3 and 4, the Date Picker field is used as the If statement, or as a trigger. You can set the State as After or Before, and set the Value as the rental date range.

    5. Integrate the form with Stripe and pass the calculation to the payment field.

    • Select the Payment field and click on its Wand icon.
    • Choose User Defined Amount under Payment Type.
    • Select Total under Get Price From.

    How can I change the price to correspond to the selected date? Image 4 Screenshot 93

    That's it. You should be able to use just one form to book the rental reservations. And the price will correspond to the date that the user will select. 

    How can I change the price to correspond to the selected date? Image 5 Screenshot 104

    Give it a try and let us know how it goes.

  • rentacarokinawa
    2023年11月9日 0:42に返信

    Hi, Mightor

    Thank you for the information. However, I'm unable to select this calculator option in my form (Stripe form), and I'm still unclear on how to implement this. Could you please tell me where to start or provide a bit more guidance?




    How can I change the price to correspond to the selected date? Image 1 Screenshot 20

  • Rica Support Team Lead
    2023年11月9日 2:52に返信

    Hi rentacarokinawa, 

    Thanks for getting back to us. You will have to change the Payment Type to User Defined Amount to pass the value from the Form Calculation widget to the payment field. What you are trying to achieve is not possible if you use Sell Products as the payment type.

    How can I change the price to correspond to the selected date? Image 1 Screenshot 20

    The instruction provided by my colleague Mightor is a workaround so that the amount that needs to be paid will change based on the Rental Date. Please follow all the instructions provided in this reply and you will all be set.

    Give it a try and let us know if you need any help.

  • rentacarokinawa
    2023年11月10日 6:34に返信

    Hi Rica

    I'm encountering a new issue. The amount is set to 44,000.00 in the form's financial settings, but it is being displayed as 44. Could you please investigate this with the utmost urgency?

    How can I change the price to correspond to the selected date? Image 1 Screenshot 30 Screenshot 10

    How can I change the price to correspond to the selected date? Image 2 Screenshot 41 Screenshot 21

  • Nozomi_K Jotform Support
    2023年11月10日 7:11に返信

    こんにちは、IJ レンタカー様。

    この度はJotformサポートにお問い合わせいただきありがとうございます。フォームの件でご迷惑おかけいたしまして申し訳ございません。新しいご質問をこちらのスレッドに移動させていただきました。こちらからご回答させていただきます。

    宜しくお願いいたします。