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

0
votes
1answer
36 views

change value of an item in validation

I am using list validation and I want to use an IF statement where is changes the value of a field. Say IF([column 1] >2, column2 = 'hello' If true, column3 = 'no' if false) Is this possible using ...
8
votes
5answers
5k views

How do I trigger the default form validation without submitting the form

I'm customizing the NewForm of a list item and need to trigger the default form validation from my JavaScript, but I don't want the form to be submitted, since I'm doing that in a callback later on. ...
1
vote
1answer
250 views

Check for Valid User via Button

Ok, so I have a form that has multiple views, some read only and some editable. Each form has buttons to open the other forms in either edit mode or read only mode based on a field being set to ...
2
votes
0answers
71 views

how to validate fields with html5 & sharepoint 2010 webpart?

Recently, I tried to get validated fields with RegularExpressionValidator. When I deployed the webpart, the click event is not working as expected. I hear that RegularExpressionValidator is not ...
0
votes
2answers
403 views

Cannot save sharepoint page with my custom webpart (with asp.net validation controls)!

I am using sp2010. I have created a visual webpart in Visual Studio 2010. In this webpart I have created a sort of contact form with fields and a button. I have deployed this webpart to my sp site and ...
2
votes
3answers
560 views

Required attribute is ignored on Dropdown and Radio field

It seems that Site Columns defined as Type="Choice" ignore the Required="TRUE" attribute when it comes to form validation on the Edit/New pages. In this sceanrio, I chose to not define a default value ...
1
vote
0answers
107 views

SharePoint Custom Validation with ValidationFormula

I was wondering if there was a way to execute a validation using the SPField.ValidationFormula before you use SPListItem.Update(); I would like to know that a field is not valid before I execute ...
2
votes
1answer
996 views

Making Presaveaction() wait for SP.UI.ModalDialog response

I am using the Presaveaction() to perform pre-new/edit form validation. Once all fields have been validated successfully I would like to offer my users the ability to 'Save and Exit' or 'Save and ...
1
vote
0answers
425 views

SP DataTimeControl validation issue (error message does not disappear after choosing correct date)

I write simple WebPart with few asp.net controls. I have problem with validation control and SharePoint date time control. The markup: <SharePoint:DateTimeControl ID="dtc" runat="server" ...
2
votes
2answers
117 views

Date Format Modifcation in List

I would like to format a new column with the Month and Day of another column. Is there a way to accomplish this? I tried adding this =TEXT([Date of Birth],"MM/DD") in column validation but it gives me ...
2
votes
1answer
399 views

Visual Web Part Property Validation in Sandbox Solution [SharePoint Online 2013]

How can I validate a custom web part property in a Sandbox solution (SharePoint Online 2013 environment)? I am throwing a WebPartPageUserException when validation fails, as shown below. private ...
0
votes
1answer
26 views

Nearest thing to allowing entry of text or date in list

I have a list which collects the dates that systems were lasted tested on. Ideally therefore, I would like it to be a date field. This way, SP uses built-in functionality to validate the entries. ...
2
votes
1answer
62 views

Are SharePoint versioning possible to validate according to Food Safety Standards?

Use Case: I often tell future customers that “Sure, you will have previous versions available for those with the right permissions”. While that is true, I wonder if I can get away with that statement ...
1
vote
1answer
104 views

Column Validation

I got 8 columns in my List(calendar reservation). I want to have one column(Approval: YES/NO) only visible to a user("testuser"). How can we use column validation *expressions* to archive this. ...
0
votes
3answers
59 views

IF Statement - may need re-writing

I am using an IF statement to allow both a-z and A-Z characters (shown below). +(IF(OR((AND(CODE(MID([Field],1,1))>64, CODE(MID([Field],1,1))<91)), (AND(CODE(MID([Field],1,1))>96, ...
2
votes
2answers
136 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
784 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 ...
3
votes
3answers
13k views

Column validation syntax in 2010

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
64 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
106 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
864 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 ...
1
vote
3answers
4k 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
1k 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
6k 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
4k 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
59 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
706 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
2k 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
741 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
240 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 ...
1
vote
1answer
709 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
1k 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
741 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
367 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
359 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
2k 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
781 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
3k 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
2k 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
622 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
391 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
253 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
175 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
225 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 ...
3
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
3k 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
3k 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
107 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 ...