Skip to main content
Question

QB Email address field still accepts nonsense. How?

  • September 23, 2020
  • 0 replies
  • 32 views
Hey all,

I honestly thought i'd never have to raise this question. I was hoping that it would have been fixed after so many years.

Why does your Email address field allow invalid and multiple @ characters? There must be an amazing explanation as to why this has not yet been addressed? Why would you even need an Email address field, when I might as well add a Text field and Regex it so it does what I want?

QB Email address field allows the following:

myemail@cool@yahoo@yahoo.com --in what world is this valid?
myemail@  yahoo.com --again, space after @ and it still works
  myemail@yahoo.com  --two spaces before email, two spaces after, still works

​​

------------------------------
Vince Admin
------------------------------
    This topic has been closed for replies.

    • BlakeHarrison
    • Quickbase Alumni
    • September 29, 2020
    Valid concern, but I would recommend submitting something over on UserVoice here.

    ------------------------------
    Blake Harrison - DataBlender.io
    Quick Base Solution Provider
    ------------------------------
    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • September 29, 2020
    Maybe this will help.  If you improve it, pleas post back

    var text email = Trim([Quoted Dealer Email]);

    var text Warning =If($email="", "Missing email address",

    List( "<br>",
    If( not Contains($email,"@"), "Missing @ symbol" ),
    If( not Contains(Part($email, 2, "@" ),"."), "Missing .com or similar at the end" ),
    If( Contains($email, " "), "Has a space inside the email address" ),
    //If(Part($email, 1,"<>[]{},")<>"", "Bad characters in in the email address"),
    If(Part($email, 2,"<>[]{},")<>"", "Bad characters in in the email address"),
    If(Begins($email,"<"), "Bad characters in email address"),
    If(Ends($email,">"), "Bad characters in email address"),
    If(Contains($email, "mailto"), "Bad email address"),
    If(Contains($email, ":"), "Bad email address" ),
    If(Ends($email, "."), "email ends in a period - that can't be right" ),
    If(contains($email, ")"), "email contains a bracket ( or ) - that can't be right" )

    ));

    If($Warning<>"", "<font color=red>" & $Warning)

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
      Terms & ConditionsAccessibility statement