coupons for calculated fields transferred to payment tool

  • SunbridgeInstitute
    Asked on January 6, 2016 at 10:35 AM

    Hi there! I am creating a fairly complex form which requires that I list my products outside of the payment tool, and then transfer the total in using the Custom Amount Payments.

    I am very surprised to find that I no longer can use the coupon feature of the payment tool. This is very unfortunate, since I was planning to have several different coupon codes for users. How can I get around this now?

    Thank you so much.

  • Charlie
    Replied on January 6, 2016 at 1:10 PM

    Apologies for the inconvenience. I believe the coupon code function is not available for custom amounts.

    But you can easily set this up using conditional logic. Here's a test form: https://form.jotform.com/60054771381958.

    Basically, we'll have an "Initial Total" field to fetch the initial values. To apply a coupon code, we'll have a text box named "Coupon Code" and set conditions that will calculate the final total.

    1 => The values from the radio button field will be pass on the "Initial Total"

    2 => Is an example of condition that will check if the "Coupon Code" inputted is equal to "ABC123", it will deduct 50% from the "Initial Total" and pass it on the "Final Total" field.

    3 => If coupon code is not equal to the coupon code setup, then pass the "Initial Total" to "Final Total" without any deductions or discounts.

    coupons for calculated fields transferred to payment tool Image 1 Screenshot 30

     

    Here's one of the coupon code I have setup:

    My coupon code "ABC123" will discount 50% on the initial total fetched from the product value.

    coupons for calculated fields transferred to payment tool Image 2 Screenshot 41

     

    I hope that helps.

  • SunbridgeInstitute
    Replied on January 7, 2016 at 11:51 AM

    How can I add more than one coupon code? I thought it would be as easy as adding more conditions, but it doesn't seem to be working. I just cloned your form and added an additional condition saying "if coupon code equals alum15, then formula is Initial Total * 0.85

    Then when I go into the form preview, and select a product, then type alum15 in the coupon code box, it does not change the total.

    Here is the form where I tried this out, if this helps: http://www.jotform.com//?formID=60055715524956

    Thank you so much if you can help.

  • Charlie
    Replied on January 7, 2016 at 1:43 PM

    I made some improvements, I see there was a flaw in the order.

    So here's how I set it up with an improved version. Here's my cloned form again: https://form.jotform.com/60065306142949 

    1. This is now the order of the data flow

    Products => Has calculation values on it

    Coupon Code => The text input where coupon code will be stored

    Initial Total => This is where we want the condition to happen now.

    Final Total => We will fetch the value from "Initial Total"

    coupons for calculated fields transferred to payment tool Image 1 Screenshot 40

     

    2. Here, we will directly do the calculation in the "Initial Total".

    The calculation in the condition would be like this:

    Condition #1:

    IF "Product" is filled out

    THEN

    "Product" value is inserted in "Initial Total"

     

    Condition #2:

    IF Coupon Code is equal to "ABC123"

    THEN

    "Product" value * 0.50 and insert it to "Initial Total"

     

    Condition #3:

    IF Coupon Code is equal to "alum15"

    THEN

    "Product" value * 0.85 and insert it to "Initial Total"

    coupons for calculated fields transferred to payment tool Image 2 Screenshot 51

     

    3. Now for every condition for a coupon code, you need to also add it in the "IS NOT EQUAL TO" condition block.

    What this condition does is if the coupon code is not VALID and if coupon code is empty then we will get the value of the "Initial Total" and insert it to the "Final Total".

    coupons for calculated fields transferred to payment tool Image 3 Screenshot 62

     

    Let us know if that works.