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

    Is it possible to bulk import information into conditions?

    Asked by CUPSCommunity on May 17, 2017 at 11:16 AM

    Hi,

    I'm looking to have certain fields in a form I created show up only to my paying clients, so if a lead uses the form we can show them something different. My plan is to use their email, which they enter earlier in the form, with an "IF email contains xxxxx, then show/hide" condition. The problem is that we have like 400 clients - is there any way to either bulk import these or integrate it with a google sheet where we have all our clients? We can knuckle down and do the data entry if we have to, but wanted to see if there's an easier solution first.

    Thanks!

    Page URL:
    coverthatshift.com/book

  • Profile Image
    JotForm Support

    Answered by BJoanna on May 17, 2017 at 12:44 PM

    You can copy list of email addresses from spreadsheet and paste it to your condition and use Contains state. This way you will have to set only one condition inside of your form if you want to hide and show multiple fields base on email address that was entered. You will need to separate email addresses with a comma and a space, like this:

    Here is my demo form: https://form.jotformpro.com/71365057371961 

    Hidden fields will be shown only if email address test1@gmail.com, test2@gmail.com, test3@gmail.com or test4@gmail.com is entered.

    Feel free to test it and clone it

    Hope this will help. Let us know if you need further assistance.

  • Profile Image

    Answered by CUPSCommunity on May 17, 2017 at 01:00 PM

    That's perfect. Thanks!

  • Profile Image
    JotForm Support

    Answered by BJoanna on May 17, 2017 at 01:15 PM

    You're welcome.

    Feel free to contact us if you have any other questions.