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

11
votes
2answers
13k views

Validate if the entered text is number

Is it possible to write column validation to check if the entered text is number? I have a column named Year of type Single line of text. I would like to be able to stop the user if he or she enters ...
9
votes
5answers
9k 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. ...
8
votes
4answers
3k views

List Validation does not show Error when Conditions are not met

I am using List Validation feature for a list which is working fine i.e. doesn't save the item when condition not met. However, it is not showing the error message which helps to rectify the inputs in ...
5
votes
5answers
4k views

How to validate Web Part property value?

A custom web part has custom web part properties. I would like to validate with custom server side code when user changes property value (or when properties are bing saved). Is that possible? Can I ...
5
votes
2answers
94 views

Sharepoint 2013 built in date validation

I'm trying to use the 2013 built in date validation. I want to make sure the date entered into the GoLive Date is not more that 10 days in the past. =[GoLive Date]>[GoLive Date]-10 How can I turn ...
4
votes
1answer
12k 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 ...
4
votes
3answers
19k 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 ...
4
votes
1answer
119 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 ...
4
votes
1answer
2k views

SharePoint Form - Advanced Validation Error Handling

Our company wants to create a more user friendly and branded way of handling user errors when validating InfoPath Forms. We would like to create a message box that essentially would be more ...
3
votes
1answer
772 views

How can I make sure that only one of two fields is filled out (ListItem)?

I have custom SharePoint list with several fields. Two of the fields are TargetPage and ExternalURL. At the moment the user is allowed to fill out both of them if he want to, and I want to deny that. ...
3
votes
2answers
33 views

How can I validate number column

I have number column in my new form. If user write here number, I need to validate if it is multiple of value 0,5. For example 1 or 2,5. I've tried formula for column validation: = ?*0,5 but it ...
3
votes
3answers
733 views

Getting Value of Radio Button on SharePoint 2013 Edit Form using jQuery

EDIT: updated verbiage to reflect this is specifically a Radio Button choice field. The below script works when the choice is set to display in a drop down. I'd like to be able to do the equivalent ...
3
votes
4answers
906 views

Validate a column only on edit

I have a date field that's now allowed to be >=TODAY(). But this validation should only be run IF the field have been edited. The field is present in a form with other fields. And if any of these ...
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 ...
3
votes
1answer
465 views

Check if a Date field is greater than another Date field

I am working on an issue tracking list and I added two custom fields of type Date/Time which allows date only, as follow: Plan start date. Plan end date. How can I check that the start date is ...
3
votes
1answer
2k views

Form validate - New item

I have a list on Sharepoint, and when some user add a New item, I need to validate fields... I would like something in jQuery... something that if the field is not validated, it shows a msg error and ...
3
votes
2answers
3k 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
53 views

Column validation only when creating new item Sharepoint 2010

So I have a date field that needs to be a future date when the item is created. The formula I have set up for that is: =[Date Required]>TODAY() This works well however I am running into an ...
3
votes
2answers
33 views

Valdition Column Formula for Choices (Compelted, Not started, Inprogress)

In my Task list I got a column named "Status" with 5 different choices, Not Started In Progress Deferred Waiting on someone else Completed In my task, when it is set to Completed I want the Column ...
3
votes
1answer
155 views

Can I prevent duplicates to a SP2013 list with a validation formula?

I have a SharePoint 2013 list and want to use 2 columns as sort of a natural key on the list, so when a user enters a new entry, if these 2 columns combined match an entry already in the list, it ...
3
votes
1answer
377 views

Survey, validate today's date question

We have a private survey. The date the survey was completed is to appear in an Exported Excel sheet. To do so, I have added a Date Field question in the survey named something like "Today's date" ...
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 ...
3
votes
1answer
808 views

dropdown box(sharepoint form field) validation sharepoint 2010

I have a sharepoint form field(look up field), a dropdown box in a list...below is the screen shot when i type into it it finds the name.. but when i type a text which is not present in the drop ...
3
votes
1answer
37 views

Create multiple custom error message(user message) for validation in list

How to create Create multiple custom error message(user message) for validation in list ? Ex: I created a long validation formula ,I want to generate a specific message based on wherever my ...
3
votes
0answers
39 views

Multiple validations in a single column in 2013

I have been working on something I feel should be very simple for far too long. I have a single line text column in a list and would like to employee multiple validations to the column. The ...
3
votes
0answers
147 views

How do you validate a column only if it's new item being added? [duplicate]

I recently added validation to a field which works great. =[Arrival Date]>=TODAY()-5 However, I ran into an issue when an employee is editing an older item to update the "Status" but it's not ...
2
votes
1answer
1k views

Custom form validation

I am new to Infopath and Sharepoint, and have been reading everything I could find online about this, but nothing to solve my problem. We need a form with custom validation (logic in javascript) to ...
2
votes
1answer
228 views

How to validate a sum of percentage from multiple fields before creating a new item?

Here's the situation that I'm facing. I have three (number-type) fields which should add up to 100%. What I want is to be able to dynamically validate that after I input the number into the 3 ...
2
votes
1answer
1k 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 ...
2
votes
1answer
2k views

Validate a date column against a lookupfields additional column

In a list you can create a lookup column which queries data from an other list, the fun part is that you can add "additional columns" which results in some sort of ghost column which is added to the ...
2
votes
1answer
43 views

Make a column mandatory based on value of another column

I have created an action list and when the status column is set to 'closed', I would like the 'date closed' column to automatically populate with the current date. If this is not possible, it would ...
2
votes
1answer
46 views

Disable validation for BaseFieldControl until save button is clicked

I have webpart with webpart user control and webpart config control. The problem is that the when I save options in config control, field validation in user control validates fields (BaseFieldControl) ...
2
votes
1answer
64 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 ...
2
votes
2answers
2k views

How to make SharePoint fields mandatory conditioned on other fields?

For example, in a workflow task, I might have a master field called "Approve" which, if set to "No", makes it unnecessary to complete the rest of the form (and thus makes them non-mandatory). Is there ...
2
votes
3answers
701 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 ...
2
votes
2answers
168 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
2answers
196 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 ...
2
votes
2answers
392 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 ...
2
votes
0answers
22 views

Validating Today's Sum

I have a column indicating how many tokens are used for an event. The daily threshold is 42, and a user is not allowed to exceed that limit. What validation formula would I use to return "You've ...
2
votes
1answer
41 views

How to Display Friendly Error Message in InfoPath

I have a validation rule in InfoPath that fires if RequestStatus = Ready and Value (Color control) is not present or in this case blank shown below: Below screenshot shows when the validation kicks ...
2
votes
1answer
59 views

Phone number column validation

I want to add phone number column with below format: 1-121-343-6917, 434-5503 & 60-12-444 444 Used below method =TEXT(123456 ,CHOOSE( LEN(123456) ,"0" ...
2
votes
2answers
44 views

column validation in 2013

Hopefully I can explain this well enough, I am working in 2013 and I have created a form with 21 fields. There are eight fields that are required from the start, one of those required fields has six ...
2
votes
1answer
139 views

Show error message when custom Ribbon button is disabled

I have a custom button added to SharePoint Ribbon. And there is EnabledScript attribute of the CommandUIHandler for the button. This attribute contains a javascript code to conditionally ...
2
votes
0answers
337 views

Person Is Valid SharePoint User [MultiUser]

I have a list with column named 'MultiUser' [DataType: Person or Group, Multiple Selection Yes] I want to validate all the Users in List using SharePoint Designer. I can do this if there is only one ...
2
votes
0answers
82 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 ...
2
votes
1answer
474 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 ...
1
vote
3answers
3k views

Email validation in SharePoint 2010

We have a column of type "E-Mail" and we'd like to attach validation to it so it conforms to the normal regular expression email validations at a specific domain. Is this possible without writing a ...
1
vote
2answers
40 views

Column validation- User must enter A or B as first character

I am trying to create a validation formula which will verify that the user entered A or B as the first character in the column. Can't seem to get the formula right. Can anyone help? [EDIT] One ...
1
vote
3answers
4k views

how to get Relative Url using Jquery in Sharepoint Site?

in my sharepoint site first i want to get Host URL(/Site URL ),and user enter Relative URL in TextBox then i want to append that relative url with Host Url Using JQuery and nedd to check that url ...
1
vote
1answer
7k 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 ...