How Do I Compare a user-submitted field, say a membership ID against the one in our membership database in

  • Profile Image
    Asked on March 16, 2016 at 12:56 AM

    We want to validate whether someone is a member or not before allowing the person to redeem a coupon. So how do we use jotform with getresponse such that when the user enters his membership ID, it is compared against a member id column in the database which is on getresponse?

  • Profile Image
    Answered on March 16, 2016 at 03:13 AM

    I do believe it is not possible to compare the membership id from with the submissions in jotform. The GetResponse integration from jotform only transfers the submissions to the Getresponse contacts.

    A possible workaround I could suggest would be to create this sort of check using the AutoComplete Widget. Basically you could enter in a list of the Membership ID you want to allow to redeem a coupon. You could then have it use a condition set for a secondary field to have it check this to see if it matches then allow them to redeem the coupon. 

    Here's a demo so you can see it in action:

    You can also clone it to your account by following this guide: How to Clone an Existing Form from a URL

    If you need further assistance, do let us know.

  • Profile Image
    Answered on March 16, 2016 at 04:07 AM

    Dear Chriistian,

    Thanks, but it does not seem to be what i want - although i must say it's getting closer to what i need.

    Can I;

    1) Export the member-id (about 10 000 records) from GetResponse and import into JotForm.

    2) So when a user types in the member ID and clicks "Submit" or "Validate", jotform will compare the user submitted ID with the list that was uploaded into JotForm?



  • Profile Image
    Answered on March 16, 2016 at 04:51 AM

    Unfortunately, what you require is not possible in jotform. To achieve your requirement, you would need to store the member-id in a database such as MySql. Then using the form's full source code, you would add custom programming outside of jotform to validate the data entered in the form with the list of members in the database.