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

3
votes
0answers
43 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
1answer
232 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 won'...
3
votes
1answer
784 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 ...
0
votes
1answer
55 views

Colums validation gives error

I want to create an input form in SharePoint. In this form you have to select a date. It must be the date 2016/01/20 or 2016/01/27 (in my country it's called 20.01.2016 and 27.01.2016. The column is ...
0
votes
1answer
41 views

Enforce Unique Values Across 3 Columns

I have a list with 3 columns that are currently relevant: Customer Code | Product Line | Part Number I want to enforce unique values across all 3, so that at least one value of the three columns ...
1
vote
3answers
68 views

Column validation failed

I have created column validation to enter only positive integers with 2 decimal. But I'm unable to key in integers with decimal. I'm not sure what went wrong. Please assist. Column validation ...
2
votes
1answer
64 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" ...
5
votes
2answers
113 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 ...
0
votes
1answer
45 views

Column validation based on another column

I have a list where users can fill a column named "External effort (m/d)" (type of column is number). After that column, I have "External resource cost" column, which type is currency, and where users ...
0
votes
1answer
46 views

Can we add client side validation to workflow initiation form (without infopath)?

We are using SP2013 standard so Infopath form service is not available. By using SharePoint Designer 2013, I copied and renamed the OOB workflow "Approval - SharePoint 2010" to build a new workflow. ...
1
vote
1answer
1k views

attach file in sharepoint list, validation with attachment

Is there anyway to have a field that can link to a document. Like the attach file but an actual column field. If not is there anyway to use the attachment as a validation. So if there is no attachment ...
1
vote
0answers
86 views

Trigger standard new/edit form validation from custom button code behind

I've got a standard new and edit form with one custom button on it. I want to trigger the usual form validation, when the button is clicked and ONLY execute the code behind the button when the form ...
2
votes
1answer
59 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) ...
0
votes
1answer
176 views

Conditionally Require Data in SharePoint List Columns (cannot be blank)

I am working on a List where if a certain entry is edited/marked as "Closed" in the Status column, then the Resolution Date cannot be blank, and should not let the user save the changes (Stop Editing ...
0
votes
1answer
61 views

How to validate the total value of multiple Number columns in a list?

In a List, I've got several number columns that users enter a value in for # of tickets. Ex: Event 1 - [ ] tickets Event 2 - [ ] tickets Event 3 - [ ] tickets Is it possible to validate the ...
1
vote
1answer
81 views

Validation Settings Not Showing in List Settings SP2013

I can't see an option for Validation Settings or Catalog Settings for my list in SP2013. What permissions should my admin provide me in order for those two options to show? These are the settings ...
1
vote
1answer
552 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" DateOnly=...
0
votes
0answers
19 views

Restore viewstate while cancelling request

I have a SPItemEventReceiver with custom ItemAdding handler. When any exception occurs (frequently it's just a model validation) it handles this exception in Handle method. Now it looks like this: ...
0
votes
1answer
47 views

Column Validation help

I am struggling to get my column validation to be accepted. This is the logic I am trying to replicate: IF "Status" = "Successful" THEN "Date Completed" must be populated AND "Date Completed" IS ...
0
votes
0answers
60 views

Validate over-20 dropdown lookup column

I have a lookup column with over 20 items so it displays the more complex (input element) dropdown menu. The trouble I'm having is that users can type anything into that input, even if it does not ...
0
votes
0answers
54 views

SharePoint Validation Email Formula not working

I am trying to make a validation for email field, using this post: https://www.premierpointsolutions.com/training/help-and-how-to-articles/how-to-validate-an-email-address-using-column-validation-in-...
1
vote
2answers
91 views

Site column validation - not allow to use slash / backslash / questionmark / \?

Got a script that creates new site collection based on a template (clone site collection). Problem is that some users type in slash / backslash in the title site column, that makes the url wrong. ...
0
votes
2answers
43 views

sharepoint list validatation code not working

I have three fields in a list called Level 1 data incident, Level 1 data incident(Yes), and Level 1 data incident(No). Based on Yes or No selected from a drop down option only the appropriate field ...
0
votes
1answer
93 views

how to put validation using script in sharepoint 2013?

i want to set validation using multiple fields in Newitem.aspx. e.g. if user select type "Sick leave" and number of days are > 3 then he must add "attachment". i tried with presave action but it's ...
0
votes
0answers
537 views

List Form Jquery Save Button (validate, save, redirect) error. Is there anything wrong with our syntax?

We have a custom list form that we are trying to save, validate, and redirect. We can get the button to save and validate, but not redirect. And vice versa. We have tried several variations on the ...
0
votes
1answer
121 views

Strict Text Formats in SharePoint Online

In my SharePoint Online list I have column Serial# and I want Serial# in a specific format like 5CB34307L8, 2CE0031NWX For example if I type 512,bc1 it should be converted automatically into 512BC1 ...
0
votes
1answer
46 views

Validation Formulas

Could someone please help me with the following: I want to validate the documents added in sharepoint only if they have the Project name and the Contractor name. Can you please let me know what ...
0
votes
0answers
32 views

Group Validation Error When Adding an Attachment

I have an InfoPath form and workflow set for a list in SharePoint 2013. I am receiving the validation error: Field or group: my:group_2 Error: No exact match was found. I have reviewed the ...
2
votes
2answers
49 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
251 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 fields....
0
votes
2answers
57 views

Validate a date to a specific month

I'm using SharePoint Online and in one of the lists I have a date field that need a special validation. The date register by the user must belong to a specified month, and this month most be ...
0
votes
4answers
587 views

number field to limited digits without comma in sharepoint list

On my SharePoint online site I have a custom list with a Number field.I want to apply validation on this field so that the Number should not be less than or greater than 5 digits and it should be ...
0
votes
3answers
490 views

How to Implement Field Validation on Click of Submit button on Custom Form

I've created a custom form in SPD 2013. On my form, I've got a series of required fields. I coded the OnClick feature of the "Submit" button of my form so that when a user submits the form, a ...
0
votes
0answers
116 views

Validation Error how to move screen to error message

Currently on my SP site when a user submits/edits a form and a column validation error occurs the screen refreshes but stays where it is (so if you have scrolled to the bottom it refreshes you at the ...
0
votes
2answers
41 views

validation control not working

I am using sharepoint validation control to validate only numbers but whatever i enter it says "please enter valid number". What is wrong with my validation expression? <SharePoint:...
1
vote
1answer
48 views

List validation, no duplicates choices

I'm having issues with validation on SP2010. I've created a list with 8 possible shifts my employees can choose and want them to select their most to least preferred shift. I've also set it to they ...
1
vote
1answer
231 views

Validating a set of dates in Microsoft Sharepoint

I am trying to validate dates in a task request form that has a column of [Date of Request] (which would be the day that they are adding the task to the main hub. I, then, want that [Date of Request]...
0
votes
0answers
14 views

Validations not working in Sharepoint 2010 at all, Both list and column validation will not affect my request form? [duplicate]

I have a task request form that has a column of [Date of Request] (which would be the day that they are adding the task to the main hub and I need to validate two dates within a form I have [Date of ...
0
votes
0answers
14 views

Validating dates on a form in Sharepoint and validation will not work at all anywhere, what can I do? [duplicate]

I am trying to validate dates in a task request form that has a column of [Date of Request] (which would be the day that they are adding the task to the main hub. I, then, want that [Date of Request] ...
0
votes
1answer
1k views

Column validation for US phone number format

I want to validate the field for US format phone number(478-857-4578). I used the below code, it works fine for all but one scenario. If I enter only 4 digit number or below than, the error message ...
1
vote
0answers
23 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 ...
0
votes
3answers
416 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
271 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
63 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
289 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 ...
1
vote
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 ...
9
votes
5answers
10k 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
121 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 ...
0
votes
1answer
401 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
20k 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 ...