Tuesday, July 17, 2012

New Features of "List" in SharePoint 2010

There are so many new features introduced in 2010 related to List and fields

In that most intresting futures are

Referential Integrity:-

As you know, with SharePoint 2007 we can create relationship between lists using Lookup field. But now, List in SharePoint 2010 also supports Referential Integrity with another list. So if you have two lists Student and Department, you can create a referential integrity constraint (Cascade Delete or Restrict Delete) between them.

Cascade Delete: Means if item in the parent list is deleted all the associated items in the child list will also be deleted (just like in SQL Server)
Restrict Delete: If an item in parent list is associated to items in the child list, then this item in parent list cannot be deleted unless its association with all the items from the child list is removed.

Another one Unique column which allows us for storing unique data which is not possible in SharePoint 2007

Column Validation
In 2010, without developer code an end user can write his own formulas to validate the custom columns, for example If your column is called "Company Name" a valid formula would be [Company Name]="My Company" and we can write our custom validation message by using user message attribute.

Customize List forms using InfoPath 2010
This is another beautiful future, using this option from List tab we can customize List newform, edit form and display forms using infopath, in 2007 we need to use SharePoint designer and customize the List form views, I think using Infopath we can validate input data and make pages more beatiful than SP Designer.

Refer bellow blog for more information
http://malikhan.wordpress.com/2009/12/20/new-features-of-list-in-sharepoint-2010-part-12/

No comments:

Post a Comment