Email / Phone validation in SharePoint 2010 Column validation

=(LEN(LEFT([Email Address],FIND("@",[Email Address])-1))>0)+(LEN(RIGHT([Email Address],LEN([Email Address])-FIND(".",[Email Address],FIND("@",[Email Address]))))>0)+(LEN(MID([Email Address],FIND("@",[Email Address])+1,FIND(".",[Email Address],FIND("@",[Email Address]))-FIND("@",[Email Address])-1))>0)+(ISERROR(FIND(" ",[Email Address]))=TRUE)=4

--------------------
Phone Validation (example: 123-456-7896x486):

=AND(LEN([Phone Number])=16,IF(ISERROR(FIND("",[Phone Number],1)),FALSE,(FIND("",[Phone Number])=1)),IF(ISERROR(FIND("-",[Phone Number],4)),FALSE,(FIND("-",[Phone Number],4)=4)),IF(ISERROR(FIND("-",[Phone Number],8)),FALSE,(FIND("-",[Phone Number],8)=8)),IF(ISERROR(FIND("x",[Phone Number],13)),FALSE,(FIND("x",[Phone Number],13)=13)),IF(ISERROR(1*CONCATENATE(MID([Phone Number],1,3),MID([Phone Number],5,3),MID([Phone Number],9,4),MID([Phone Number],14,3))),FALSE,AND(1*CONCATENATE(MID([Phone Number],1,3),MID([Phone Number],5,3),MID([Phone Number],9,4))>1000000000,1*MID([Phone Number],1,3)<>911,1*MID([Phone Number],5,3)<>911,1*MID([Phone Number],5,3)<>555,1*MID([Phone Number],14,3)<>911)))

Comments

Post a Comment

Popular posts from this blog

SharePoint 2016 and 2019 Ports

http://sharepoint2016server.blogspot.com/2016/10/sharepoint-2016-ports-list.html SharePoint 2019: Distributed Cache : TCP Port 22233, 22236 : UDP Port N/A : Protocols ICMP Type 0 (ping) People Picker : TCP Port 53, 88, 135, 137–139, 389, 445, 636, 749, 750, 3268, 3269 : UDP Port N/A 53, 88, 137–139, 389, 445, 749 : UDP Port N/A : Protocols N/A Sandbox Service : TCP Port 32846 : UDP Port N/A : protocols N/A Search Crawler : TCP Port Web Application Ports Used (e.g., 80, 443) : UDP Port N/A : Protocols N/A Search Index : TCP Ports 16500–16519 : UDP Port N/A : Protocols N/A Service Applications : TCP Port 32843, 32844 : UDP Port N/A : Protocols N/A SQL Server : TCP Port 1433 (default) : UDP Port 1434 (default) : Protocols N/A WCF Services : TCP Port 808 : UDP Port N/A : Protocols N/A User Profile Service : TCP Port 53, 88, 389, 5725, 1025–5000, 49152–65536 : UDP Port 53, 88, 389, 464 : Protocols N/A SMTP : TCP Port 25 (default), 587 (TLS default) : UDP Port N/A : Protocols
Read more

PsConfig step by step /Configuration Wizard. “Upgrade Available” vs “Upgrade required”

Image
The "Upgrade available" simply means that there is a newer patch available at the SharePoint Updates page than the one installed on your SharePoint farm. We checked the Farm version and made sure its the latest available version. Getting "Upgrade Required" error message in SharePoint 2013? Well, Ideally, We have to run the SharePoint Products Configuration Wizard on the server(s) right after installing the service pack/patches. In Windows Server 2012, SharePoint updates are part of Windows Server Update. It installs patches but never runs Products configuration wizard automatically! You still have to run psconfig wizard to complete patching! ----------------------------------------------------  https://www.sharepointdiary.com/2014/02/upgrade-available-server-status-after-sharepoint-patching.html https://www.sharepointdiary.com/2015/03/upgrade-required-status-in-sharepoint-central-admininstration.html https://blog.stefan-gossner.com/2015/08/20/why-i-prefer-psconfigui
Read more

Unlock the SharePoint site using Powershell command

if your SharePoint site locked, then use the below Powershell command to unlock. Note: Lock means your site will be disabled all actions (creating new item, library/list settings, limited site action menu etc.,) even if you are site collection administrator. if you try to add another user as site collection administrator using powershell/central administrator, then will get the following error. this error because of SharePoint Lock. Additions to this Web site have been blocked To avoid above errors. use the below Powershell command Set - SPSite http : //SiteCollectionUrl -LockState Unlock
Read more