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.
- formula checkbox - [Contains @]
If(Contains([Email], "@"), true, false)
then use that checkbox in form rule. - Trim([Contact email])<>"" and Contains([Contact email],"@") and Contains([Contact email],".")
- Thank you both, this is very helpful. I guess at this point what remains is the core issue, which is that this approach would not work if users were creating or updating records via grid edit (unless this option is disabled) or uploads.
- Quite true. In the future, I would expect that QuickBase would support field level validation rules so that we would not have to rely on form rules which don't work in grid edit.
But until then you can do a safety net Subscription report back to the [last modified by] of any invalid email addresses entered yesterday.
Just set up a daily 5 days a week Subscription report where the validation is false and the [Last Modified by] is the "current user". - Or you could use the image on load technique with some modified script as per this post by dan.
https://community.quickbase.com/quick...
