Is it possible to bulk import information into conditions?

  • Profile Image
    CUPSCommunity
    Asked 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!

  • Profile Image
    BJoanna
    Answered 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
    CUPSCommunity
    Answered on May 17, 2017 at 01:00 PM

    That's perfect. Thanks!

  • Profile Image
    BJoanna
    Answered on May 17, 2017 at 01:15 PM

    You're welcome.

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