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
2answers
952 views

Validation on a list using IF, AND and ISBLANK

Im trying to validate my list in SharePoint 2010, so that it will only proceed when a column = xyz and a date column is not empty. I took a stab at the syntax and came up with this. ...
0
votes
1answer
954 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 ...
0
votes
2answers
28 views

Can not edit webpart on newform.aspx without filling in required fields

We have a set of sitecollection, with around 30 lists, where the forms do not appear as modal windows. Everyone of those now needs a new webpart added. Adding the webpart itself works. When I edit ...
1
vote
1answer
785 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
2answers
71 views

Checkbox required not validating

According to http://stackoverflow.com/questions/8045235/infopath-2010-validate-i-agree-checkbox-before-submitting you can set a checkbox to "required" and it will validate that they have to check it ...
0
votes
1answer
914 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 ...
3
votes
0answers
25 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
46 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
183 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
37 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
28 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 ...
0
votes
2answers
8k views

Trouble opening Excel Document

I have Microsoft Excel 2007 and am trying to open and edit a document from my Employer's SharePoint (I am not sure what version of SharePoint they are running, unfortunately). I have attempted to ...
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 ...
1
vote
1answer
839 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 ...
1
vote
3answers
51 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
43 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
61 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
30 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
17 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
933 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
40 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 ...
3
votes
3answers
258 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 ...
2
votes
1answer
27 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
47 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
31 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
26 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
480 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" ...
0
votes
0answers
14 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
41 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
42 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
44 views

SharePoint Validation Email Formula not working

I am trying to make a validation for email field, using this post: ...
1
vote
2answers
69 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
31 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
375 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
102 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
42 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
25 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
32 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
131 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 ...
0
votes
2answers
49 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
332 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
216 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
76 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
36 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? ...
1
vote
1answer
46 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
108 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 ...
0
votes
0answers
12 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
408 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 ...