Coupon field and Discount calculate

  • Profile Image
    Asked on April 04, 2019 at 05:53 PM


    I need realize a "eCard" for my customer.

    The customers subscribe a form (N.1) and receive a virtual aCard (PDF) wit a code, unique code, generated in the form. I can do it, is not difficult.

    In a second form (N.2) my customer select a product and the quantity they want and they receive the price. Easy.

    If I want us this code from the first form (saved inside a list, maybe external) in a field of the second form to make a discount, is it possible this?



  • Profile Image
    Answered on April 04, 2019 at 08:09 PM

    I think that would not be possible to do since it's not possible to compare values with an external list, what you may do is have a list of predefined list of coupon codes and provide it randomly to your users, then have the spreadsheet to form widget and link a sheet with the second form where you ask the coupon code, then if it's in the sheet then you may apply a discount. 

    This guide will help you implementing the spreadsheet to form widget: 

    This guide will help you performing the calculations: 

    I hope this helps. 

  • Profile Image
    Answered on April 05, 2019 at 12:43 PM

    Ok, I try to find a solution with your suggestion.

    A question more.

    If I have this list of Unique ID (AA1, AA2, ...) I can charge with the spreadwheet widget:

    AA1 - 31/01/2019
    AA2 - 31/01/2019
    AA3 - 31/01/2019

    AB1 - 28/02/2019
    AB2 - 28/02/2019
    AB3 - 28/02/2019

    AC1 - 31/03/2019
    AC2 - 31/03/2019
    AC3 - 31/03/2019

    When the customer make a new subscription, Can I send a Unique ID (the code) from the first three of the list if today we are in january? From the second if we are in february? ...

    Is important understand the alphanumerics code (AA1) are Unique ID. I need to send always one different.

    If is it not possible this condition. Forgets the dates. Can I simple send a Unique ID from the list?



  • Profile Image
    Answered on April 05, 2019 at 01:54 PM

    Your second question will be addressed in a separate thread: