Validate Email Address Columns in SharePoint

=AND(
    ISERROR(FIND(" ", [Email],1)),
    IF(ISERROR(FIND("@", [Email],2)),
        FALSE,
        AND(
            ISERROR(FIND("@",[Email], FIND("@", [Email],2)+1)),
            IF(ISERROR(FIND(".", [Email], FIND("@", [Email],2)+2)),
                FALSE,
                FIND(".", [Email], FIND("@", [Email],2)+2) < LEN([Email])
            )
        )
    )
)

=OR(ISBLANK([YourColumn]),AndStatementFromAbove)

Comments

Post a Comment

Popular posts from this blog

How to Create an Auto-Incrementing Number Field in a SharePoint List

Auto-numbering is a common requirement when working with SharePoint lists. You may want an auto-incrementing number on Issues list items such as “ISS-001” and so on. If you try using calculated column with ID field and entered a formula such as = (“ISS-00” & [ID]), this won’t work for new items! The reason being ID field is filled ONLY after the item is created. Here are the steps to create an auto-incrementing number field in a SharePoint list designer workflow: Create a new column, such as :  Increment Number  in issue list with Number type. Make this column hidden in a view. Create another column, such as :  Issue No.  in issue list with Formula type and add the following formula = “ISS-00” & [ Increment Number ]. This Column will show the increment items’ numbers in the list. Open SharePoint designer, create new list workflow (for issues list). Add a workflow action: “Update list Item” >> Current Item >> Add >> Set thi...
Read more

SharePoint Integration with IIS

Image
Before discussing the Integration, we will discuss the architecture of SharePoint at the architecture level. The diagram represents the architecture of SharePoint and split into two halves. The Left-half is administrator world and the right-half is the end-user world. Everything in right half resides in SharePoint content database. Let's continue with some terminologies before goes into deep dive.  Farm A farm is a logical architecture or logical grouping of SharePoint servers that share common resources of SharePoint. It can be a single machine or more than one machine. The farm is differentiated on their tier levels. Might be possible Farm can be 1to N-tier. Installation can either be done at 1 machine to N. Most of the cases in production you have to choose at least 5-tier architecture for application Server, front-end  Server , SQL, AD+DNS, Office Web App Server and Exchange; you can add more than one application server, Front-End etc at any level. C...
Read more

Error:Installing product D:\exchangeserver.msi failed. Fatal error during installation. Error code is 1603.

Error 1603 is a known Microsoft/environmental issue. This error message is displayed by the Microsoft Windows Installer Engine and is a general error code that indicates a problem occurred during the installation. The following is a non-exhaustive list of known causes for this error. Short file name creation is disabled on the affected machine. An Install Script custom action is prototyped incorrectly. A file is locked and cannot be overwritten. The Microsoft Windows Installer Service is not installed correctly. The Windows Temp folders are full. The setup was corrupted after installation and therefore fails with this error during un-installation. An older version of Install Shield Developer is being used. A general error occurred during the installation. Print and File sharing is not installed or enabled when installing MSDE 2000. For more information please visit -  http://support.microsoft.com/kb/834484/en-us Resolution To resolve this issue, complete th...
Read more