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

1
vote
0answers
19 views

need additional validation

I am looking for a simple way to perform an input validation or input control in newdocset.aspx. I need to avoid any “.” (dot) in the name to avoid a later performed path generation. I have tried ...
1
vote
2answers
2k 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 ...
0
votes
3answers
334 views

Why does this multi-field validation forumula work in Excel but not in SharePoint 2013?

Why does my simple formula work in Excel but not-work in SharePoint? Why does this formula... =IF([Request Type]="Review",(IF(ISBLANK([Request Date]),FALSE,TRUE)),TRUE) ...work in Excel but fail ...
0
votes
1answer
146 views

Custom validation in newform/editform using jquery

I have an "Issue list" and I am writing some jquery code to validate some fields based on the status of the issue. I am using PreSaveAction() function to make the validation, but I see that the fields ...
1
vote
1answer
44 views

Validation Formulas not working on a specific site

I have troubles using validation formulas on one specific site. Within a large sharepoint I was working on one site and had no problems using validation formulas. Now I now want to implement these ...
0
votes
1answer
159 views

List Validation for Single line of text and multiple line of text

I need to validate in item list, that all defined text fields are filled with text if a choice is set with "valueB"; With choice "valueA" the text field may not be filled. I solved this with list ...
0
votes
1answer
2k views

List Validation Settings - Multi Line formatted Columns Missing from Create Formula

I have a custom list in which some specific fields need to have additional validation which I am implementing through Validation Settings. However, on the Validation Settings page, when I go to ...
8
votes
5answers
8k 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
0answers
84 views

Sharepoint 2013 client document library Column validation

I try to upload file to document library with metadata. When I enter validation for one column the file does not upload even data is correct or incorrect. Always show this exception List data ...
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
219 views

Require field to be not null in sharepoint list

I have several columns to input a number, the field is required with a default value of zero. This works fine when filling out the form, but once they save it then go back into the form the user can ...
4
votes
3answers
17k 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 ...
1
vote
0answers
46 views

InfoPath list box - How to change the validation message “Only numbers allowed”?

This is SP2010, InfoPath 2010. I've got an InfoPath form. Form has a listbox which is bound to external data. The Value is a number, and the Display is a descriptive list for humans. I have, in the ...
0
votes
2answers
55 views

How to Determine if One or More Fields in Custom Edit Form have Validation Errors

So I have a DVWP with an Edit Form. The form uses jQuery tabs to organize the fields for the different roles that edit the item. I would like to show a message at the top of the form if at least one ...
1
vote
1answer
405 views

How to change required field error message?

I have two required columns in a custom list. When adding an item using OOTB new form, the required field validator shows same error message You can't leave this blank. For both required ...
0
votes
0answers
62 views

Check on username in custom list validation

I have a list adding records. I need put a validation in a List column for the column named "Target Date". I went to List Settings, Validation Settings and added the formula and the User message. ...
0
votes
2answers
129 views

How do i prevent duplicate entires based on multiple criteria

How would I prevent duplicate entries into a list from being entered based on the status of a different item on the list. For example, I don't want someone to enter an new list item if they have an ...
0
votes
2answers
187 views

Sharepoint 2010 custom new form column validation

I have a custom list and custom New Form created using Visual Studio. Now I wanted validated a Amount column whether the value is less a value from another List column. I also have Newform.cs file. ...
0
votes
0answers
38 views

How to implement validation warning in page layout for column “Title”?

I am using sp 2013. I have created a custom page layout. I would like to implement an validation warning on the "title" and "comments" columns. Something like "It is not possible to use more than ...
1
vote
1answer
17 views

Site collection Validation

While restoring a site collection, what all properties can be taken into consideration for validating the restore. (Say for example, if I have a a properties of the site before backing it up.. And I ...
0
votes
0answers
87 views

Error while adding a file to document library with the following code

I am using the following code to add a file to my document library, but it keeps giving me List data validation error (even if the values are correct!) myHashtable.Add("Text","Valid"); ...
0
votes
0answers
33 views

Validation for column choice

I am creating an event registration list using Sharepoint and have a column with the choices session 1, session 2, session 3 etc. How do I set a validation rule to limit the number of items for a ...
0
votes
1answer
127 views

SharePoint 2010 List Validation not working as expected for DataFormWebPart

I created a custom list and kept the "Title" as unique and required. When I use the ListFormWebPart in "NewForm.aspx" all the validations work fine, i.e. for required and dulicate entry it shows ...
0
votes
0answers
77 views

Validate that text field matches a format zero or more times

I have a "single line of text" column in my list that needs to contain zero or more numerical values, separated by semicolons, with no spaces, letters, or other characters. The contents of that column ...
1
vote
0answers
71 views

Sharepoint List Form Javascript get validation results

Is it possible to find out using javascript/jquery if a SharePoint 2013 new/edit list form throws validation errors? Something like: if(page.ValidationFailed) //do something I do not won't to ...
0
votes
2answers
281 views

Column Validation for day Monday OR Friday

I'm working with a date and time column and need a validation that returns true if the day of the week is Monday OR Friday. Users are not permitted to add an item on any other day of the week. ...
0
votes
0answers
30 views

List Data Validation still fails for document library when data is valid

I have a document library with a column with Column Validation. Whenever I try to add a file to the document library, it fails even when the data input is valid! try { file = ...
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 ...
0
votes
0answers
54 views

Validate Number Column not to accept comma

I want to use ootb column validation to not accept the comma in number field. Can anyone suggest to me what a formula would look like?
0
votes
1answer
479 views

Fields validation with Javascript in custom WebPart - SharePoint Online -

I'm currently developing a SandBox WebPart for SharePoint Online (2013) which have two TextBoxes. I'm trying to add the following code for validate the Email and Subject TextBoxes once the Button ...
0
votes
1answer
23 views

Validation upon initial entry

I have a new SharePoint list in which the user enters an item number along with other information. Is it possible to check the item number for all other item numbers in the past 7 days. If it exists, ...
0
votes
1answer
18 views

Data Validation

I have a list in SharePoint. It collects the date it was entered and then a Dynamic Column called Days in House. This column should update by subtracting the creation date from today's date and ...
0
votes
1answer
90 views

How to specify a specific range of dates

I have a List that tracks certificates. I need to limit two of the input fields and I'm not sure how. I have a formula (=[Expiration Date]>[Last updated]) in place that prohibits an Expiration ...
0
votes
2answers
46 views

Validating Password based on nested IFstatements and FIND function Problem

I am having trouble figuring out how to validate multiple special characters in SharePoint 2010 when a user inputs a password. The special characters that are allowed are: !@$*#%&^)+ . When i have ...
1
vote
1answer
341 views

c# - how to validate sharepoint list column against ValidationFormula programmatically

I need to validate a string that user submit against SPField.ValidationFormula while adding new record to custom list in c#. Line to add new record is SPListItem item = mylist.Items.Add(); I have ...
0
votes
1answer
31 views

Help with list validation please

I'm trying to do a validation in one of our list. Basically, I have a Drop Down box with 5 choices (let's say choice1 to choice5). If choice2 OR choice3 is choosen, I'd like to have a mandatory ...
0
votes
1answer
115 views

Change in jQuery code from SharePoint 2010 to SharePoint 2013

I'm migrating a SharePoint 2010 VS project to SharePoint 2013. The project has custom list definitions and custom add, edit and view forms and uses jQuery 1.8.3. In 2010 the following code works fine: ...
0
votes
2answers
43 views

List Form Validation Logic Not Working as Expected

I'm trying to include Validation Settings for my List Form where I've got a column called Food Service and another column called Food Service Type, where Food Service is a "Yes/No" type column and ...
1
vote
1answer
46 views

column validation syntax

Trying to compare 4 fields (only if populated) against one another so that no data is duplicated? I've tried something like this but gets too long. =IF(LEN(f1=1), ...
0
votes
1answer
115 views

Email address validation error

I have an EMAIL column and added this validation code: =AND( ISERROR(FIND(" ", [EMAIL],1)), IF(ISERROR(FIND("@", [EMAIL],2)), FALSE, AND( ISERROR(FIND("@",[EMAIL], FIND("@", [EMAIL],2)+1)), ...
0
votes
1answer
245 views

Unique Validation on Calculated Column

I have 2 columns (first name and last name) in a SharePoint custom list. I have a calculated column called "full name" just concatenates the first and last name columns. Due to requirements, I need ...
0
votes
1answer
186 views

Column Validation Forumla Question Regarding Special Characters and ASCII

I've run in a problem writing a formula that will basically validate what the user enters. So for example, i need a user to input a password using the following criteria: 12 characters long 1st ...
0
votes
0answers
109 views

Data Inputing in Multi-Line text box and specified type

Good Day all, Im new to sharepoint, I have been ask to test sharepoint to see if it would do what we need, in terms of data inputing for our specific data model. The input is important as we need to ...
0
votes
1answer
146 views

Task %Complete calculated column show date/time

Im trying to create a calculated column to show completion date of a task based on %complete. So if the task has hit 100% then it should autofill a date/time value based on this percentage.
0
votes
1answer
489 views

Person Group type column not listed on a custom list's Validation Settings page

I have a Person Group type site column that I am using in a custom list through content types. On the Validation Settings page of the list I cannot find that column listed in the selection list of ...
0
votes
0answers
91 views

SPUtility.ValidateFormDigest breaks ASP.Net server side validation

I have a Web Part which is using SPSecurity.RunWithElevatedPrivileges, and thus needs to call SPUtility.ValidateFormDigest. However, this apparently causes it to ignore all ASP.Net validators server ...
0
votes
1answer
50 views

ValidationFormula to include 2 datetime fields

I have a custom list which is created via code. It has 2 fields for start and end date. When I specify the ValidationFormula with the 2 fields, the code errors out. Is there a way to validate the 2 ...
0
votes
0answers
120 views

MAC input validation in SharePoint 2010 list

I would like to validate the input of a MAC address in a list and have gotten the formula 90% there. The final step that I'd like to accomplish is to set any upper-case characters to lower. I know ...
0
votes
1answer
409 views

validate Unique users in 2 columns sharepoint List

I have a list which stores information about new sharepoint site requests. Where i have 2 fields (people and Groups) Primary Site Collection Admin Secondary Site Collection admin Both of this ...
0
votes
1answer
891 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) < ...