-
Virginia_WindsI need to collect students' emails, but they cannot be their local school email addresses, as we are blocked from sending emails to students' email addresses within the schools' domains.
We have plenty of notices to NOT enter school emails, but it happens more often than not.
We want to have a mirrored, hidden, short text file and then check whether the schools' domains are in it.
However, the JotForm conditions are case sensitive, making this a very, very difficult problem.
This would be easier if we could test against =UPPER(emailMirror).
Any suggestions would be appreciated
John FLahive
Virginia Winds Academy
VirginiaWindsAcademy@gmail.com
703-919-7026
-
Rehan Support Team LeadHi John,
Thanks for reaching out to Jotform Support. Are there any specific domains in the school email addresses? If so, then we can use them to conditionally hide the submit button and display a warning message encouraging students to use a personal email. I've checked your form, and I can see that you created a Thank You page condition to display if the email field contains FCPS and LCPS. If these values are part of the school email addresses, then we can definitely use them.
So we will be creating a Show/Hide condition to display a warning message and hide the submit button if FCPS or LCPS is used in the email field. Let me show you how:
- In Form Builder, in the orange navigation bar at the top of the page, click on Publish.
- Then, in the menu on the left side of the page, click on Conditions.
- Now click on Add Condition, then select Show/Hide Field condition.
4. Set the condition as you see below:
On a side note, the conditions are not case sensitive. So it will detect if the values are written in small letters. Here is our warning message that will be displayed in a Paragraph field.
Here is the result in a cloned form:
Try that and reach out again if you need more help.