- CUPSCommunityAsked on May 17, 2017 at 11:16 AM
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.
- JotForm SupportBJoannaAnswered 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
Feel free to test it and clone it.
Hope this will help. Let us know if you need further assistance.
- CUPSCommunityAnswered on May 17, 2017 at 01:00 PM
That's perfect. Thanks!
- JotForm SupportBJoannaAnswered on May 17, 2017 at 01:15 PM
Feel free to contact us if you have any other questions.