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
1answer
23 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 ...
0
votes
1answer
14 views

Validation Error When Submitting Custom Infopath Form on Sharepoint List

I recently created a new list for our employees to create new Goals using sharepoint. I created a content type called “annual performance goals” and created a custom new entry form using infopath to ...
0
votes
1answer
33 views

Character Limit

How do I setup a character limit in a specific column to limit the amount of characters?
0
votes
2answers
20 views

Formula for sum validation

UPDATED QUESTION: I need a validation formula (no client side java) that ensures the following: Fields: Time 1 = Total Time in hours (i.e. 8 or 8.5) Time 2 = Optional Subset1 of total time Time 3 = ...
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 ...
0
votes
2answers
121 views

Conditional dropdown validation

I have a dropdown named "Status" with a "Yes" and "No With Reservation" as options. If the user choose "Yes", form can be submitted, if "No With Reservation", user must fill out an "Explanation" ...
1
vote
1answer
927 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
2answers
9k 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 ...
2
votes
1answer
27 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 ...
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
248 views

Validation formula on new items only

I'm using the following formula to prevent users from entering spaces on the article name field. =ISERROR(FIND(" ",ArticleName)) The problem is the users have already entered data in this field ...
2
votes
1answer
27 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 ...
0
votes
2answers
69 views

Jquery conditional dropdown validation question

I have multiple Sharepoint dropdowns validation but I will show only two on my code. I can't seem to find where the problem is. The logic is if the user choose from any dropdown values <> "yes" ...
0
votes
1answer
1k 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 ...
1
vote
1answer
842 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?
3
votes
1answer
34 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 ...
1
vote
1answer
16 views

InfoPath 2010 Validation not Working As Expected

I have an issue with Validation in InfoPath 2010. I'm using IP 2010 with 2013 SP List. Below is step by step of the issue I'm encountering: Below is part of a form in IP. The controls are a Radio ...
0
votes
1answer
29 views

Column validation accept a specific character and numbers only

So far I manage to make a validation that makes the column only accept numbers: =ISNUMBER([Column_Name]+0) But I want users to be able to type ";" inside as column value so only numbers and ...
1
vote
0answers
49 views

SP2013 column validation error message issue

I'm using on-premise Sharepoint Server 2013 and within my site collection I need to apply field validation formula to document library using document set content type. In case formula is used for ...
1
vote
0answers
32 views

Sharepoint 2010 Validation by two fields

I have a SharePoint list with these fields: Destination - User picks a person Created by - User who created the item Is there a way to prevent users from creating item for themselves using ...
1
vote
0answers
28 views

Limiting the number of items in a list

I'm trying to limit the number through the use of validation settings. I was hoping of creating the max number of forms, then forcing it so no forms can be created. But I still would want the forms to ...
1
vote
2answers
39 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
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 ...
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 ...
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 ...
0
votes
0answers
19 views

Sharepoint Column Validation Error - Not going to second page

I added column validation to the drop-down choice questions on page 1 of my survey and it worked fine. The last question of my survey page 2 has branching logic and column validation. When I ...
1
vote
0answers
16 views

Validating multiple columns - one date, one yes/no

I'm having trouble figuring out how to make sure that if "yes" in the yes/no option is chosen, that a date must be entered in the "when" column and vice versa. In summary, did you buy a car? if so ...
1
vote
2answers
2k 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
2answers
36 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 ...
0
votes
2answers
122 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
973 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
37 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
113 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
350 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
47 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
32 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
61 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
56 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
83 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
35 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
28 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
79 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
644 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
44 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
95 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
38 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
46 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
520 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" ...