How do I set a specific price that shall be depended on the day of the month?

  • Malcolm Partridge
    Asked on May 8, 2017 at 11:44 AM

    hi

     

    i want to create a field that creates a payment based on which day of the month they join my health club.

     

    i want to charge a different amount if they join on the 1st of the month to say the 10th of the month.

  • liyam
    Replied on May 8, 2017 at 1:22 PM

    The idea that you can use here is by making use of a form calculation widget for payments. You can check this quick guide for more information: https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field

    But in addition, you will need to make use of a dateTime field, a regular textbox field that will capture the date, and a substring widget to parse the date and get the day of the month only.

    Once you have the day of the month, you can then either set a condition for your specific amount for that certain day, or create your calculation.

    This may come to be too technical and tedious so let me show you a sample form on how it shall work: https://form.jotformpro.com/71275372170958

    We can start from that form and then set our journey on to creating your form :)

    Note: you can hide the field and set it to load on the current date as default.

    We'll look forward to your response.

  • MPartridge1
    Replied on May 8, 2017 at 1:33 PM

    That looks perfect.

     

    If only i had your knowledge.  How do I go about doing that?  Can I then use htat generated price to auto load into my stripe box?

  • John_Benson
    Replied on May 8, 2017 at 2:44 PM

    Hello,

    We have a user guide and a video on how to use the Form Calculation widget, here's the link: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget.

    You can actually clone the form created by my colleague Liyam. Here's a guide: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL.

    Yes, you can pass the value of the Form Calculation widget to the Stripe payment integration. You just need to set the Payment Type to "User Defined Amount/Collect Donation" and the Get Price From "Calculation widget". Here's a complete guide: https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field.

    How do I set a specific price that shall be depended on the day of the month? Image 1 Screenshot 20

    We also have a guide on how to integrate the form to Stripe. Please refer to this link: https://www.jotform.com/help/190-How-to-Integrate-Stripe-with-your-Form.

    If you have questions, please contact us again. Thank you.

     

    ---
    Related guide: 
    Setting-Up-Your-First-Order-Form

  • MPartridge1
    Replied on May 9, 2017 at 10:43 AM
    New response receivedThat sounds great. How can we proceed to make that happen on my form?
    Many thanks
    Malcolm Partridge
    Watersplash Club
    76 Barton Court Avenue
    New Milton
    Hampshire
    Tel 01425610119
    sales@watersplash.org
    www.watersplash.org
    ...
  • Nik_C
    Replied on May 9, 2017 at 12:39 PM

    Is this the form you're working on http://www.jotformeu.com/form/71215656412350?

    If that's the one, this is what you should do to apply muy colleague's solution:

    1) Add two more text fields to the form:

    How do I set a specific price that shall be depended on the day of the month? Image 1 Screenshot 110

    I called the first one get date - where the date will be copied and the second one today's day - where the day will be extracted.

    2) Add the Substring widget to the form:

    How do I set a specific price that shall be depended on the day of the month? Image 2 Screenshot 121 

    You will need the ID of the get date field, here is how to get it:

    How do I set a specific price that shall be depended on the day of the month? Image 3 Screenshot 132

    How do I set a specific price that shall be depended on the day of the month? Image 4 Screenshot 143 How do I set a specific price that shall be depended on the day of the month? Image 5 Screenshot 154

    Copy and paste the ID into the Substring widget:

    How do I set a specific price that shall be depended on the day of the month? Image 6 Screenshot 165

    3) Create the below conditions:

    -When the date is entered copy it to get date field:

    How do I set a specific price that shall be depended on the day of the month? Image 7 Screenshot 176

    -When the Substring widget is filled copy it's value to today's day, so we will have just the day in that field:

    How do I set a specific price that shall be depended on the day of the month? Image 8 Screenshot 187

    Now when we have the current day you can create conditions that will change the price, for example:

    If it is the 1st of the month:

    How do I set a specific price that shall be depended on the day of the month? Image 9 Screenshot 198

    And if it is the 10th an month:

    How do I set a specific price that shall be depended on the day of the month? Image 10 Screenshot 209

    Then you can use that value from Joining fee to forward it to the payment, as you did already pretty much.

    Hope this makes it clear. 

    If you have any further questions please get back to us.

    Thank you!

  • MPartridge1
    Replied on May 9, 2017 at 2:43 PM
    New response receivedHi
    I am almost there, I just cant seem to get the subscription field to auto update and then that in turn to get the payment field in stripe to auto update.
    https://form.jotformeu.com/71284285312353
    Many thanks
    Malcolm Partridge
    Watersplash Club
    76 Barton Court Avenue
    New Milton
    Hampshire
    Tel 01425610119
    sales@watersplash.org
    www.watersplash.org
    ...
  • Kevin Support Team Lead
    Replied on May 9, 2017 at 5:14 PM

    I have checked your form and I can see it is not updating the payment field; however, upon inspecting the conditions I can see there are errors on them, the conditions with missing fields may generate conflict between some form's functionalities and other conditions. 

    How do I set a specific price that shall be depended on the day of the month? Image 1 Screenshot 30

    Please, fix these errors and set the conditions like my colleague explained above: 

    How do I set a specific price that shall be depended on the day of the month? Image 2 Screenshot 41

    Please, update your conditions and your total should update as well. 

    Do let us know how it goes. 

  • MPartridge1
    Replied on May 9, 2017 at 6:43 PM
    Hi
    I have it working now.
    ...