.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

formula validation setting on column sharepoint 2010

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :SharePoint
Hi, Hi,  I have a two fields(mailid,cost,mailid2), i need a list validation of mailIds if already existing  mails three time I need a validation for new request , i need a formula for column in validation setting ->formula in SP2010  if mail is already existing validation  i need formula for validation setting for list it's new feature in sharepoint 2010 Regards

View Complete Post

More Related Resource Links

SharePoint 2010 - Column Validation (List Level) User Message Missing


I first saw this issue being discussed in January 2010 here, but there has not been any response in some time. 

What basically happens is when you set column validation for the list level (not per column) the message that alerts the user that the column does not meet the validation requirements is completely missing.   Both the default message or a custom message do not show up. 

Does anyone know if there is a hotfix for this issue yet?  I would expect more than a year later there would be one, but if so I can't seem to find it.  I would really like to correct this issue as column validation is a nice enhancement over SharePoint 2007.  Thanks in advance for any help.

Video: Field and List Item Validation in SharePoint 2010

SharePoint supports the ability to create Excel-like field validation formulas to validate field data in a list, which greatly reduces the amount of custom code that a developer must create and deploy. (Length: 1:44)

Problem with Retrieving data from lookup column using SharePoint 2010 Linq Concept

Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad

Laptop configuration for setting up SharePoint 2010 development environment

guys, i see a lot of new intel processors out there like I5\ I7, my question is which one is good to set up a complete hosting environment while taking it for travels. i would like to have SP 2010\ Sqlserver 2008 in VM environments. Also what kind of RAM?   thanks in advance sameer

Client side validation using Client OM in sharepoint 2010

Hi, Can we use Client Object Model for Client side validation? Suppose, i have a SharePoint 2010 List. While adding a new item in that list, i want to check for Title is already available or not, person has posted any item earlier or not..that kind of stuff. Could i check this at client side rather than ItemAdding Event, so that i can reduce the network traffic? Thanks in advanced. Hardik Shah Solution Developer.

Sharepoint Designer 2010 modified view breaks "hyperlinks" column and formats all hyperlinks to the

I have been trying to perform a simple task with sharepoint designer 2010 that keeps breaking one of my list colums (in the custom view that is).  Background:  I have a list that we are using to assist with Document control in our organization.  The list consists of a few columns: Document number, Title, Owner, Doc Type, and file link (hyperlink to a pdf).  When I create a new out of the box standard view, everything works as desired.  However, I need to adjust the column widths on a couple columns in SharePoint designer, which seems to break the file link column functionality (all of the hyperlinks are now formatted to go to the same document, thought the file paths in each list item are correct).  Funtionality of the file links column works perfectly, until I make a single change to the view in SharePoint designer and save.  Any insight on this issue would be greatly appriciated.  

Unable to update Work E-Mail in My Setting of Sharepoint 2010

Hey,   i am trying to update Work E-mail in My settings but it will not allow me to edit.   when i click on Edit Items then Attach file comes as user personal information   Please suggest me solution.   Regards, Sachin Phapale  

Currency and number column error with office 2007 document formats in SharePoint 2010 library

Hi there,



The following error occurred within a SharePoint 2010 document library:

As I tried to test out the new SharePoint 2010 environment I changed the metadata from a few documents within a document library. I noticed that the data from the currency und number field was incorrect from a few documents. The numbers looked like that the decimal separator were ignored. For an example: 123.456,78 was saved as 12.345.678.

At first I thought it could be a language incompabilty but if that would be the case: Why would there be other documents which show the correct number?


I created another document library to recreate this error. And there I noticed the real reason: Every time I changed these fields from a document which was saved in the office 2007 format the error occurred. The metadata from the documents in the office 2003 format were correct.


Has anyone a similar problem or got an idea how to solve this problem?


System Specs:

Frontend: Windows Server 2008 SP2 ent

Create Lookup Site Column based on External List (SharePoint 2010)


I've got an External List and I want to create a Site Column, which is Lookup to a column in my external list. If I tick any of the columns in 'Add a column to show each of these additional fields' and click OK i get the following error message:

[NullReferenceException: Object reference not set to an instance of an object.]
  Microsoft.SharePoint.SPBusinessDataField.IsInDefaultView() +58
  Microsoft.SharePoint.SPBusinessDataField.CreateSpFieldForBdcType(String bdcName, Boolean hidden, Boolean readOnly, Boolean idField, SPAddFieldOptions op) +809
  Microsoft.SharePoint.SPBusinessDataField.AddNeededSecondaryFields(String wssNames, String[] oldNames, String[] newNames, SPAddFieldOptions op) +315
  Microsoft.SharePoint.SPBusinessDataField.OnAdded(SPAddFieldOptions op) +240
  Microsoft.SharePoint.SPFieldCollection.AddFieldAsXmlInternal(String schemaXml, Boolean addToDefaultView, SPAddFieldOptions op, Boolean isMigration, Boolean fResetCTCol) +759
  Microsoft.SharePoint.SPFieldCollection.Add(SPField field) +61
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.Save() +513
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.BtnOk_Click(Object sender, EventArgs e) +46
  System.Web.UI.WebControls.Button.OnClick(EventArgs e) +114
  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +139

Setting SharePoint 2010 Form Fields Using Query String Variables


Hi All,

I have a requirement to populate sharepoint form field value with query string while uploading document to document library.

While uploading the document to document library, I want to populate claim number available from query string in a pop up page i.e in my case EditForm.aspx, Located at http://servername:port/sitename/documentlibraryname/forms/EditForm.aspx.

Additional Information:

  • Created document library and added custom columns like claim number etc..
  • Created a view to filter uploaded documents as per claim number.

Server Details:

  • Windows Server 2008 R2
  • SharePoint 2010
  • SQL Server 2008 R2

I have written javascript for the same, but not sure where exactly to add the code in EditForm.aspx page.

Any help on this would be greatly appreciated.

Thanking you in advacne.



SharePoint 201 VS 2010 WF: PersistenceException: The security validation for this page is invalid


Setup: Visual studio 2010 SharePoint 2010 Workflow with custom infopath task edit form, with file attachment control. If I attach a file to the infopath task edit form, I got the following error message, though the attachment is saved, but the next task is not created and the current task is not marked as completed either.

09/27/2010 15:34:31.18     w3wp.exe (0x2B88)                           0x2844    SharePoint Foundation             Workflow Infrastructure           88xr    Unexpected    WinWF Internal Error, terminating workflow Id# 04621f32-17d4-439a-883a-7566b96481bb     
09/27/2010 15:34:31.18     w3wp.exe (0x2B88)                           0x2844    SharePoint Foundation             Workflow Infrastructure           98d4    Unexpected    System.Workflow.Runtime.Hosting.Pers

Setting Options Programmatically in Visio 2010 for Publishing to SharePoint Server 2010

Explore how to programmatically save Visio 2010 diagrams as web drawings for use with Visio Services in SharePoint Server 2010.

SharePoint 2010 Date Column Not Indexing (or not searchable)


I have a 2010 Record Center.  Indexing and search functions seem to be working.  However dates do not appear in search results.  The column is marked for indexing.  Crawling is working and I do get other text type results.  I have tried switching the column to Date & Time in the detailed column settings.  With or withouth the time, it does not come up. 

There is an interesting twist.  On SOME, the search returns the AllItems.aspx PAGE (not the documents) with the date highlighted in the result item description.

Setting up FBA in Sharepoint 2010 Foundation - Managed to lock myself out of all sites - Could reall


Sorry, I've just realised I posted this in the wrong area. If a mod/admin could move this, I would greatly appreciate it


Hello MSDN,

I have been working towards setting up FBA on my Sharepoint 2010 Foundation server, hosted by Rackspace. But while setting up .net user roles I get all manner of strange behaviour like messages about trust relationships, and have to edit the GAC. 

Now, I have managed to lock myself out of all of my sites (Including central admin), which, as you can imagine, is rather frustrating.

This isn't a mission critical server, but it would be nice to have it back online today. So if anyone knows a bit about setting up FBA, ask away and I can give any information that you require, and if necessary, I'm happy have a chat on Windows Live.


Cheers guys/

EDIT: Spelling mistakes

New Item Form with Business Data Column SharePoint 2010


I am suprised that this issue still exist with the new sharepoint 2010, I was trying to create a new page, and I inserted a "New Item Form", this list contain a business data column, when I insert a new item, the business data coulmn doesn't get saved, this issue was there in MOSS 2007



SharePoint 2010 - Note Board Webpart Setting

In SharePoint 2010 we have the "Note Board" webpart on the user profile page. We can set how many items it should show before the pagination occurs(default is 3). However I cannot find any setting(or any documentation) about how long(1 month,6 month,etc.) the comment will show up on the note board. What's the default duration of a comment on a user's "Note Board" before it expires? Can we override this setting?

2010 SharePoint global setting for document Library version control?


Apparently new Document Libraries created in Sharepoint are no longer set up the way we would like as far as version control.  Is there any way to set up SP so that any new document library created has specific settings, through Central admin control?

Jack Galante Sr Systems Engineer

i do see that previous versions this was not possible, but was curious if they changed this in 2010?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend