What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

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

    Asked by tupasiaadmin 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
    JotForm Support

    Answered by Chriistian on March 16, 2016 at 03:13 AM

    I do believe it is not possible to compare the membership id from Getresponse.com 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: https://form.jotform.me/60751595697471

    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 by tupasiaadmin 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
    JotForm Support

    Answered by Chriistian 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.