Validation checks that the product design satisfies or fits the intended usage (high-level checking), i.e., the software meets the user requirement. This is done through dynamic testing and other forms of review.

learn more… | top users | synonyms

2
votes
2answers
103 views

validation problem - I want to ignore validation if field is totally blank

We have a SharePoint List which has validation on it to check for a National Insurance number (9 characters long, 3 letters and 6 numbers). However, it's not a mandatory field, so we would also like ...
0
votes
1answer
433 views

Dashboard from Excel file with Data Validation and Protected Sheets

I want to create a dashboard in Sharepoint using data from Excel Workbooks. Each Workbook has 2 sheets: Data and Dashboard. The Data worksheet contains raw data and the Dashboard tab contains KPI's ...
1
vote
2answers
4k views

sharepoint 2010 column validation syntax

I'm trying to find information on how to form proper column validation formulas, but can't find any explanation of formula syntax. All I keep running into are snippets of formulas, what I'm looking ...
0
votes
1answer
50 views

How to validate text input in list is a multiple of 10

I am trying to use a text column, as opposed to a number column, as I don't want any of the number formatting that automatically comes with Sharepoint. I only want this column to accept multiples of ...
0
votes
2answers
95 views

Linked Field Validation

I have two fields within a list which should be dependent upon each other. When the user creates/edits a list item I need to ensure that if one of the two fields has a value then the other is ...
1
vote
1answer
549 views

Check for Validation Errors on Submit Button Click [closed]

I have an infopath 2010 form that already has some VB code behind it. I want to create a SubmitButton clicked event that checks for validation errors before it submits.. I have an example in C# and i ...
0
votes
3answers
2k views

Unable to validate sharepoint date time control

I have added a <SharePoint:DateTimeControl> in my visual web part and I want to make it mandatory. To do so I referred this link and used as per my code. My code is: <tr> <td> ...
1
vote
1answer
775 views

How to make taxonomy picker required when used in visual web part?

I have created a visual web part in which user has to specify a field's value from taxonomy picker control. I want to make that value mandatory. The control is placed successfully but when I use the ...
1
vote
1answer
3k views

List settings validation formula syntax

I have two columns within a custom list which are check boxes (yes/no). I need to ensure either one of those check boxes are selected so trying to utilize sharepoint validation settings. It seems like ...
1
vote
1answer
3k views

List validation Sharepoint 2010: How do I validate date column based on Status?

I have an Action Items list that captures [Created], [Status], and [Date Completed] columns. [Date Completed] is an optional column to be entered at a later date when the Action Item is closed. If ...
0
votes
1answer
46 views

ETA Field Validation

I have a list which has an ETA data/time control. I'm trying to figure out a way to prevent users from entering a date which is before the current date/time?
1
vote
1answer
361 views

Issue with deploying webpart in sharepoint 2010

We've created 2 webparts under a single visual studio solution as a farm environment. But after creating the WSP and trying to deploy it to our UAT, we are getting the following error This ...
0
votes
1answer
1k views

Validation formula that TEXT should not to have SPACE

Is there any validation formula which don't allow to save some value in column with SPACE in SharePoint 2010? I know that is Calculate column formula with TRIM formula but I need to validation formula ...
0
votes
2answers
553 views

Required Date Field Value in infopath SharePoint 2010

I have an infopath form with 4 buttons, each button corresponds to a different view. When the form loads, only first 2 buttons are visible and when users fills in the fields in the first two ...
1
vote
2answers
164 views

List validation on sharepoint 2010 list

I tried to add validation on sharepoint 2010 list to validate 4 columns but, the length of this validation is greater than length of text box to write the formula. Is there any way to expand this text ...
0
votes
1answer
475 views

Date field validation in SharePoint 2007

I need to limit the Date field in a SharePoint 2007 list so the users can enter date from today and up to year after. How can i do it?
0
votes
1answer
926 views

TEXT formula does not work in SharePoint 2010

I try to find difference between two date and time value in SharePoint 2010. I have two common column (date and time) and I use this formula =TEXT(Column2-Column1,"h:mm:ss") but it does not work? I ...
0
votes
1answer
383 views

Calendar Column Validation for booking after a specific time

I'm trying to write a column validation for a SharePoint calendar to ensure all bookings are after 8.30am in the morning and before 5pm at night. I've tried the following: =AND(TIME(8,3,0) < ...
0
votes
2answers
189 views

Validat Data on Date And Time Column not work on editform.aspx on sps 2010

i have a pronlem on validation on edit mode of list items. my a simple list have a column named : "StartTime" with date & time type. and i add this validate rule : "=[Created]<[StartTime]" it ...
0
votes
1answer
242 views

Column validation on managed metadata term

I would like to validate when i create a new list item that the metadata item selected is a specific item and not a top level category for example in the above you should not be able to select ...
1
vote
4answers
1k views

How to perform date validation in publishing page layout?

I have the following 2 datetime fields which are used in my custom page layout on my publishing site. Basically, when a user is editing the page I want to validate that the 'NewsLiveDate' < ...
0
votes
1answer
526 views

How do I stop rules on submit if validation fails?

I have multiple rules on my submit button, which I need to process only if the validation passes. Currently if I have validation errors, the other rules run and change the views and the function on ...
1
vote
1answer
2k views

validating a column based on a value in another column

I have a list which has [Status] and [% Complete] as columns. In the [% Complete] column, I added a validation rule to pass validation when [Status]="Complete" AND [% Complete]=100, otherwise retunr ...
0
votes
0answers
1k views

How to use Excel Functions IF and OR in SharePoint 2010?

I am trying to use multiple nested IF() functions combined with the OR() function in SharePoint 2010. In Excel 2010 it works very well, but it is not working inside SharePoint. I already tried to use ...
1
vote
1answer
572 views

List item validation using .NET Client Object Model

On a SharePoint Foundation 2010 installation, I have a list defined and have set some simple validation rules on a couple of the fields: Text field (required) Number field (required, min: 50, max: ...
0
votes
1answer
279 views

Server side validation if Javascript disabled on user's browser

I have developed a small form with 3 input type = text and one input type = submit button. The end user fills the form and submit it, but no data inserted into backend List. (probably empty form is ...
0
votes
3answers
215 views

Check if a list has the expected structure?

I must use a list in a webpart and display some data/graph/etc based on the list content (notice: this is simplified, so please do not give it much importance). To be used the list must have a ...
1
vote
0answers
130 views

Updating a value of any item in a list based on a selection of bool for one item - jQuery

So I hope this makes sense. I have a column within a list that I want to use as an active flag. There are 5 possible categories and for each category there can only be one active value. So I need some ...
0
votes
1answer
155 views

How to validate field across multiple lists

So I'm created a number of different lists and libraries with workflows attached. When someone creates a new job, the document is uploaded to the Job directory (library). If it classified as a ...
2
votes
2answers
2k views

form validation

I am new in javascript. I want to validating a form with five columns. FormDescription My Form Contain 5 input fields and one submit buttom I want following output 1.Initially submit button ...
3
votes
1answer
2k views

How do I validate a selected “choice” field in a survey?

We've got SP2010 foundation, and the other limitation is that we do not have access to SPD or any of the programmatic ways of accomplishing this. I'm looking for information about how to set this up ...
0
votes
1answer
2k views

Find out if validation errors exist in InfoPath form

Does anyone perhaps know of a way to find out at any point when a form is filled in if there are any validation errors on the page? I am having a lot of trouble with users that are not very ...
0
votes
1answer
2k views

List validation on multiple fields?

I would like to validate a list item so that if one field is true, then another must be completed. If the first one is false, then it can be ignored. =(([Start Deferment]="Specific Date") AND [Start ...
4
votes
1answer
97 views

formula to limit date entries to specific month

In my "time off" custom list I have start date and end date. I want to make the user splits up the entries if the time off spans months. In other words if the entry starts Oct 25 and ends Nov 5 I want ...
0
votes
2answers
2k views

Custom Validation on Infopath Fields? C#

How can I apply custom validation to Infopath 2010 fields which stretches beyond the basic Rules and Templates? I am looking to validate a custom field which needs to be validated much like a Credit ...
0
votes
2answers
376 views

Does web part property validation only work for visual web parts?

Suppose I define a web part property like this: private string _myString = "default value"; [WebBrowsable(true), WebDisplayName("My string"), WebDescription("A simple bit of text to ...
0
votes
1answer
173 views

PowerShell version of SPWebapplication.FormDigestSettings.Enabled?

Does some one know the PowerShell equivalent version of the following SharePoint object model code: SPWebapplication.FormDigestSettings.Enabled = false;
0
votes
1answer
185 views

Using an event receiver to validate a page

I need to evaluate certain properties of a page whenever it's being saved/published as part of a custom validation I need to implement. I notice properties has both Cancel and ErrorMessage properties ...
1
vote
1answer
649 views

Validation of dates in different fields in sharepoint

My question is on validation of dates in SharePoint… If i have two date fields – start date(& time) and end date(&time). How do i validate these, so that a person cannot pick a time in ...
1
vote
0answers
229 views

Validate list item with javascript API

I want to develop a custom datasheet view to edit a list. I add item through the javascript API. The problem is that the service doesn't control fields value. For example : - I add an item with a ...
1
vote
2answers
2k views

How to validate if entered text for a column is in Upper Case

I need to validate if the text entered in a text column is written in UPPER CASE.
2
votes
2answers
313 views

Sharepoint multi-column validation

I've got a custom list that contains multi collumns. The validation is made by a custom contenttype. Now I want a combination of two columns to be unique. Until know I did not found a way to solve ...
1
vote
1answer
229 views

How to validate that atleast one question is answered on a survey list where none of the questions are required?

I have a survey list that has 2 questions, the first being a rating with a subset of 4 criteria to rate on and the second is just a questions and comments textbox. None of these are required, ...
3
votes
1answer
9k views

2010 Column Validation Formula

This formula works fine when adding a new list item: =[Class Date]>=TODAY()+3 Basically ensuring the user selects a date greater than two days away from current date. I don't want the formula to be ...
0
votes
1answer
721 views

InputFormCustomValidator doesn't work

I have custom application page, and I need some custom client side validation. After spending hours on trying to make asp.net CustomValidator to work, I googled a lil bit and found few posts, that ...
3
votes
3answers
2k views

New Item form field validation in SharePoint

I have created a custom list with below two columns. 1. Choice with Yes/No values 2. Multiple lines of text In New Item form of this list, on click of save button I want to make field 2 mandatory ...
0
votes
0answers
90 views

Access parent field values from custom field definition

I've got a form that contains different custom fields. During vallidation of field1 I need to know the value of field2. Does anyone know how to access the field? Or perhabs it is possible to connect ...
1
vote
1answer
267 views

Turn off SharePoint Error Messages

Is there a way to turn off error messages, that are returned from InfoPath forms either having invalid data, or permissions. Here is a picture of them. I would perfer for the form to just not ...
0
votes
2answers
1k views

programmatically list validation

I'm looking for a way to implement programmatically vallidation for NewListItems/EditListItems. One way I found was: to use the ListEvents and Validate on ItemAdding / ItemEditing. But instead of a ...
1
vote
1answer
3k views

How to put DateTimeControl ErrorMessage as '*' during required field validation

There is a DateTimeControl on my WebPage which i is a ReqiredField. I have set the properties of the control as follows <SharePoint:DateTimeControl runat="server" ID="txtDOB" DateOnly="True" ...