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
1answer
964 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
1answer
4k 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 ...
0
votes
0answers
15 views

Displaying custom popup dialog when infopath trigger validation error message

I have created a custom list form using infopath 2013.I have written validation rules for Dropdown field and checked Screen Tip and Popup dialog options. But Popup Message is not displayed. Also ...
0
votes
2answers
10k 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 ...
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 ...
3
votes
1answer
78 views

Check whether PeopleEditor control contains more than one user

I have a PeopleEditor control with MultiSelect="false" on a workflow initiation form. If enter 2 names, they both resolve... the workflow just truncates it and keeps only the first entity. I want to ...
1
vote
1answer
871 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
3answers
949 views

Required Date Field Value in infopath SharePoint 2010

I have an infopath form with 4 buttons, each button corresponds to a different view. When the form loads, only first 2 buttons are visible and when users fills in the fields in the first two buttons(...
0
votes
1answer
13 views

Custom webpart with validation

I want to build a custom form, with validation in SharePoint. Is there a built in library in SharePoint to validate required field, people pickers, choice fields, or do I need to use 3rd party ...
2
votes
0answers
23 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 ...
0
votes
3answers
62 views

Workflow copy between libraries with column validation error

I get an issue when a workflow does a copy command. The workflow could not copy the item. Make sure the source and destination lists have the same columns and column settings. Libraries are ...
0
votes
2answers
94 views

Validating dates in SharePoint so they cannot choose a date before today's date, how would I write that formula? [duplicate]

I am back at this form I have people fill out in SharePoint Designer and have a new small issue, here is my formula: =AND([Requested Posting Date]>=[Date of Request]+1,IF([Date of Request]="New",[...
3
votes
1answer
55 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
51 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
36 views

Character Limit

How do I setup a character limit in a specific column to limit the amount of characters?
0
votes
2answers
22 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
38 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
130 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" ...
2
votes
1answer
68 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
262 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
75 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
73 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" ...
3
votes
1answer
64 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
30 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
38 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
64 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
33 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
36 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
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
5k 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
5k 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
36 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
24 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
19 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. =IF(AND([Status]=...
0
votes
2answers
37 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
159 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
1k 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
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
1answer
187 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
611 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
53 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
36 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
65 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
60 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
103 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
39 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
37 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 ...