Forum Discussion

TonyGonzalez's avatar
TonyGonzalez
Qrew Trainee
9 months ago

Email address validation

Is there a way to force an email address field to force it to have a "valid" email address makeup?  I realize I can't actually validate the email address itself, but I want to require them to at leas...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

Here is their formula.  You will need to enter your own company name URL where is says mycompany

https://mycompany.quickbase.com/nav/main/action/exchange/qb/library/check-if-an-email-is-valid

 

[Email]="" OR not Contains([Email],"@") OR not Contains([Email],".") OR Left([Email],1)="@" OR not Contains(Right([Email],"@"),".") OR Length(Right([Email],"."))<2

MaxCarrillo's avatar
MaxCarrillo
Qrew Member
3 months ago

Got it- thank you Mark!!