How to setup a condition to calculate discount based on month from the date field?

  • EARSForms
    Asked on July 10, 2019 at 11:13 PM

    Hello,

    I'm creating a membership form and we discount the price if they are joining after mid-year.  I can't figure out how to set a condition for that...

    For example, if after midyear I want to hide the text box for standard rates and display textbox explaining discounted rate.

    Then I would use the same condition logic to determine what PayPal values to use...

     

    Jotform Thread 1887160 Screenshot
  • BJoanna
    Replied on July 11, 2019 at 2:55 AM

    Is the issue related to your 2019 Membership App form? I inspected the form and I saw that you created the following condition. 

    1562827594condition Screenshot 10

    The condition is working fine. 

    You can create one more "Membership Plan" field and set conditional logic to show one "Membership Plan" field when it's the first half of the year and show the other when it's the second half of the year. You can then assign different calculation values to those two fields. 

    How to Assign Calculation Value

    Inside of the following guides, you can find how to perform a calculation and pass it to the payment field:

    How to Perform Form Calculation Using a Widget

    How to Pass a Calculation to a Payment Field

  • EARSForms
    Replied on July 11, 2019 at 8:18 AM

    Yes, the 2019 Membership App.. But I want to remove the '2019' and make it usable every year without the need to be modified.  In my condition just to test I did hard code '2019-06-30' but ideally I would have a condition like "If Current Month is 6, 7, 8, 9".. 

    Which actually invokes the next problem, if month is 10, 11, or 12, then membership would be for next calendar year not present year..  :-)


  • Kiran Support Team Lead
    Replied on July 11, 2019 at 10:40 AM

    You may add a Form calculation widget to the form to read the Confirmation email date and convert it to Date String as shown below:

    156285541411072019 190721 Screenshot 10

    Please refer to the guide below for Math function reference (#6 from Other functions)

    https://www.jotform.com/help/267-Form-Calculation-Math-Function-Reference

    Then you may setup a condition on this field using Contains parameter to achieve your requirement.

    156285600011072019 200706 Screenshot 21

    Please give it a try and let us know if you need any further assistance. We will be happy to help. 

  • EARSForms
    Replied on July 12, 2019 at 9:11 AM

    Awesome!  Jotform is so cool!  Thanks!!

    15629370482019 07 12 7 55 53 LowRes Screenshot 10

  • Kiran Support Team Lead
    Replied on July 12, 2019 at 9:33 AM

    Glad to see that you were able to get the issue resolved. Please do not hesitate to get back to us if you need any further assistance. We will be happy to help. 

    Thank you for using JotForm!