How to check data entry in sharepoint form?

Question

How to check textbox with another list column? I am currently populating a dropdown with a data source and then comparing the text box with the items in the drop down using javascript. Is there a better way?

The second problem I encountered is running the Validate function.

I am aware of two custom forms for adding data to a sharepoint list. One of them is created using the Dataview Webpart web part in Sharepoint Designer, and the other is created using the list form web part in the Sharepoint designer.

I have a DataFormWebPart that I created using the Sharepoint Designer Insert Dataview → Insert Selected Fields as the new form of the element. This gives the Save and Cancel buttons at the end of the form. How to intercept the Save event?

I found one solution, but it only works with the NewForm page with Cancel buttons. http://www.codeproject.com/KB/sharepoint/Control_validation.aspx

Answer 1

You will need to use an event handler if you want to check the status of several fields. You can use ItemAdding / ItemUpdating events if you want to undo an item that is added / updated.

properties.Cancle = true; properties.ErrorMessage = "Your verification message.";

http://msdn.microsoft.com/en-us/magazine/cc163318.aspx

http://blogs.msdn.com/brianwilson/archive/2007/03/05/part-1-event-handlers-everything-you-need-to-know-about-microsoft-office-sharepoint-portal-server- moss-event-handlers.aspx

Answer 2

I think you are trying to create a tool called SharePoint Form Validation .

If so, take a look at this blog: http://office.microsoft.com/en-us/sharepointtechnology/HA101054791033.aspx?pid=CH100650061033

Hope this helps!

Answer 3

can you add query strings in the formula field for validation?

eg. eg:

^[a-zA-Z]{2}[0-9]{6}[A-Za-z]{1}$ 

which confirms the availability of a national insurance number.

sharepoint says the column should = true so that I can type something like

 [column name] = ^[a-zA-Z]{2}[0-9]{6}[A-Za-z]{1}$