Email field accepting non-email values
Is there no way to ensure that an email address in entered in the correct format in an email field? We have users accidentally creating records where they enter only the name portion of the email a...
Forum Discussion
As Matthew suggested you can make a boolean field to validate the email and use that field in form rules. But you need to invent the formula code yourself. put the formal field on the form to be sure that the form rules "see" it. Forms tend to not recalculate fields which are not on the form explicitly. You can put them in a section and hide the section using form rules. If i get a chance I will look for examples of my formuals which validate, or maybe others will post some. Like exactly 1 @ and at least 1 dot.
Trim([Contact email])<>"" and Contains([Contact email],"@") and Contains([Contact email],".")