Order Form: How to change prices for classes on a weekly basis

  • Profile Image
    Asked on October 19, 2016 at 02:33 PM

    People are registering for this class every week. I want to be able to change the prices easily. Any suggestions?

  • Profile Image
    Answered on October 19, 2016 at 06:53 PM

    Thank you for contacting us.

    This is possible to change the prices manually. You will need to click on a magic wand icon to open a Payment Wizard.

    Then you will be able to edit the prices.

    If you need any further assistance, please let us know.

  • Profile Image
    Answered on October 20, 2016 at 11:52 AM

    Is there a way to set up forms that can be adjusted weekly and not done manually by going in to adjust each product? It will take hours to adjust the forms we have everyweek based on the class schedule.

  • Profile Image
    Answered on October 20, 2016 at 02:13 PM

    I'm not sure if understood correctly your request, I can see you have some classes with their schedules and prices, but how are you trying to update the price? 

    I mean, what's the base to change the price? Is it the date when the class starts? 

    Please provide us more details about the workflow you would like to apply to the payment section so we could provide a workaround for this or escalate this thread as a feature request is there is no a way to achieve what you want. 

    We'll wait for your response. 

  • Profile Image
    Answered on October 20, 2016 at 02:57 PM

    As the weeks go on, people register late. So every week i have to go in and change the form based on a pro-rated amount for the week. I am trying to have a workaround that I dont have to update 6 forms with 8 different products each based on the week they register.

  • Profile Image
    Answered on October 20, 2016 at 04:40 PM

    I think this could be achieved using calculations in the form; however, you would need to change the current payment set up type in your form.

    You currently have set up your payment field to sell products, but if you would like to update, for example, the price automatically based on the date the payment is being done, then as you will use calculations you will need to change the payment type to custom defined amount, this way you can process the calculation separately and then capture it in the payment field. 

    As you want to change the price based on the date the form is being submitted, then you will need to first capture the current date, to do this, add the date time field to your form: 

    Once the field has been added, click on it and set the current date as default in the top toolbar: 

    Then you may add one date time field per product you set up and set the date to the one you've currently set up in your payment field, I mean, if for example one of your classes beings on October 21st, 2016 then you will need to set up this as default date and this way you will be able to compare both dates, the date set up in the product as well as the current date.

    As you will update a product's price based on the dates comparison you will need to use the Form Calculation widget to get the difference in days between both dates and then a condition to change the price if the set up date has been passed.

    This is how the Form Calculation should be set up.


    This is how the condition should look like:

    This way you will know if the date when the form is being submitted is greater than the date the form should have been submitted and then update the price based on this without the need to manually update your forms.

    Here are also some guides that will help you to better understand how to apply calculations in your form and how to pass the result to a payment field: 



    Please if you have any question, let us know. 

  • Profile Image
    Answered on November 02, 2016 at 01:18 PM

    I am sorry, but I am really confused here. 

    There is a user defined amount payment option not a custom defined amount. Is that what I should change it too? How can I set the form for Current Date and also the date the class is starting at?

    Can you make a test form with one of these on it?

  • Profile Image
    Answered on November 02, 2016 at 05:45 PM

    Apologies if I was not clear in my explanation above. 

    Yes, the option that you need to select in the payment wizard is the "User Defined Amount": 

    This will allow you to capture the value of a calculation and then take it as total and charge this to your customer. 

    Here are also some steps that I have followed in a sample form that I made for you, do note that this form only has one product so far, but it is applying a fee based on dates. 

    First you will need to add a date field where you will capture the current date:

    And you set a current date by clicking on the date field on the option default date on the top toolbar, here you should select the option "Current":

    Then you will need  to add the class or product, I have chosen the check box field since if user changes his mind he could simply un-check the option, using radio buttons this will not be possible, but if you want you could also try it with radio buttons: 

    Once the product / class has been added you will need to set a value to the option you have added, this will be the product / class price and this guide will help you to set it up: How-to-Assign-Calculation-Value

    In my example I have added 100 as calculation value. 

    Now, the next steps is to add the second date time field to your form, this will be per product / class so each one with expiration date  should have one of this, once you have added the field click on the default date option and set the date that you want.

    With these dates fields you can now check if the date when the form is being submitted has been already passed, to achieve it you will need to add a Form Calculation value where you will add the needed calculation to get the number of days that have passed, you will also need to add a Form Calculation widget per product / class: 

    Now you need a field where you will insert with conditions the fee value if the current date is after the date you've set up in the product / class. 

    And here is how it should be the condition to calculate the additional value:

    Do note that this condition needs to be added for each product so if you add a second product then you need to add a second condition and so on. 

    The next steps is to add another Form Calculation widget to your form where you will capture the final amount that will be passed to the payment field: 

    Then the final step would be to add the payment field to your form, set it up to get a "User Defined Amount" and set the proper calculation widget:

    Here is also a guide about passing a calculated value to the payment field: https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field 

    This is the link to my form where you can take a look how it should work, and also feel free to change the current date field value so you can see how the fee is applied: https://form.jotform.com/63067015959967 

    You can also clone it by following this guide: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    If you have any question, please let us know.