SharePoint 2010 Column Validation for EMail

Formula:
1.Insert the following formula in the column validation section:
=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])
   )
  )
 )
)
Source: http://thechriskent.com/2012/08/16/validate-email-address-columns-in-sharepoint/

2.Add a calculated column with the formula below:
=(LEN(LEFT([Email],FIND("@",[Email])-1))>0)
+(LEN(RIGHT([Email],LEN([Email])-FIND(".",[Email],FIND("@",[Email]))))>0)
+(LEN(MID([Email],FIND("@",[Email])+1,FIND(".",[Email],FIND("@",[Email]))-FIND("@",[Email])-1))>0)
+(ISERROR(FIND(" ",[Email]))=TRUE)
=4
Type: Number or Integer
Reference:
http://sharepointsolutions.com/sharepoint-help/blog/2011/12/how-to-validate-an-email-address-using-column-validation-in-sharepoint-2010/

Configure Send to Connection in SP 2010

Central Administration>
    General Application Settings>
           Under External Service Connections
                  Configure send to Connections

Check the Allow sites to send to connections outside the site subscription and in Send To Connections

In Connection Settings section give the following

Display Name : Display name in the drop down you want it to appear.

Send To URL :
(http://test/RC/default.aspx)

Check the box allow manual submission from send to menu

Send To Action :

Now, if you click on the the drop down of any document, you will see the option to directly send the documents to above destination.

Recommendate: To send documents to Record Center from other sites

Display all the items created in current month

In calculated fields you can use the following formulas to get first day of month and last day of month.

First Day of Current Month Formula=DATE(YEAR([Created]), MONTH([Created]), 1) 

Last Day of Current Month Formula =DATE(YEAR([Created]), MONTH([Created])+1,1)-1 

Current Month:

Filter: First day <[Today]

          Last Day>[Today]

Resource Throttling

List View Threshold: Number of items to display at one view (users). For managing Large Lists.
List View Threshold for Auditors and Administrators: For Auditors and Admins
List View Look up Threshold: For Workflow status column limit, Look up column limit
List Unique Permissions Threshold: Unique Permissions limit

Multiple File Upload Error

The reason for this issue is 'Microsoft.mshtml.dll' has not been deployed in GAC (Global Assembly Cauche "C:\WINNT\assembly"). This dll file available in the "C:\Program Files\Microsoft.NET\Primary Interop Assemblies".

 

Follow one of the following deployment procedure.

 

1) Use GacUtil command tool

    gacutil /i "C:\Program Files\Microsoft.NET\Primary Interop Assemblies\Microsoft.mshtml.dll"

 

2) Open two explorer windows. One for "C:\WINNT\assembly" and another for " C:\Program Files\Microsoft.NET\Primary Interop Assemblies" and then drag and drop the 'Microsoft.mshtml.dll' to the first window.

Some quick sharepoint troubleshooting settings

 

Function	Add to the URL	Notes
Add Web Parts Pane	?ToolPaneView=2	Add to the end of the page URL; WILL ONLY WORK IF THE PAGE IS ALREADY CHECKED OUT
Create New Site Content	/_layouts/create.aspx
List Template Gallery	/_catalogs/lt
Manage Site Collection Administrators	/_layouts/mngsiteadmin.aspx
Manage Sites and Workspaces	/_layouts/mngsubwebs.aspx
Manage People	/_layouts/people.aspx
Manage User Permissions	/_layouts/user.aspx
Master Page Gallery	/_catalogs/masterpage	Also includes Page Layouts
Modify Navigation	/_layouts/AreaNavigationSettings.aspx
Recycle Bin	/_layouts/AdminRecycleBin.aspx
Site Column Gallery	/_layouts/mngfield.aspx
Site Content Types	/_layouts/mngctype.aspx
Site Content and Structure Manager	/_layouts/sitemanager.aspx
Site Settings	/_layouts/settings.aspx
Site Template Gallery	/_catalogs/wt
Site Usage Summary	/_layouts/SpUsageWeb.aspx
User Alerts	/_layouts/sitesubs.aspx
View All Site Content	/_layouts/viewlsts.aspx
Web Part Gallery	/_catalogs/wp
Web Part Page Maintenance	?contents=1	Add to the end of the page URL
Workflows	/_layouts/wrkmng.aspx

InfoPath form hide/disable fields based on the SharePoint Group Members

http://www.sharepointbasic.com/2011/11/infopath-form-hidedisable-fields-based.html

CAML Builder and AD Explorer

U2U CAML Builder

http://www.u2u.be/Tools/SharePointCamlQueryBuilder.aspx

CAML Designer

http://karinebosch.wordpress.com/my-articles/caml-designer/

AD Explorer:

http://technet.microsoft.com/en-us/sysinternals/bb963907.aspx

ULS Logs:

http://archive.msdn.microsoft.com/ULSViewer

XML Tool Box:
Generates XPATH:
http://www.xmltoolbox.com/index.html