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

0
votes
2answers
43 views

Multi field validation in custom list - code not working

I have a custom list with JavaScript to toggle the choice field. I now need to validate the fields according to the selection. My code below throws and error - incorrect syntax. =IF([Red_Blue]="Red", ...
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
1answer
20 views

List Validation formula help!

I am creating a record center and am having issues trying to have one column (column1) get information from end user and that their answer (choice-dropdown) will determine next set of options that ...
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 ...
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 ...
1
vote
1answer
15 views

SP 2010: Make managed metadata field mandatory on condition

I've a list where there is a choice field A and a metadata field B. I want the metadata field B to be a required field if an option xyz is selected on the choice field A. How can this be achieved?
2
votes
4answers
2k views

ASP.Net Validators part of Custom control in WebPart

Custom control has 6 buttons in which 5 of them have CausesValidation = false, the one remaining button ( lets calls it as "SUBMIT") which cause validation. Edit: Validators and Submit button are ...
3
votes
4answers
941 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 ...
1
vote
1answer
885 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
1answer
18 views

Validate time field in 00:00-23:59 format in Sharepoint 2010 list using cell validation

I want a column that only accepts values of the format 00:00 through 23:59. I would like for this to be accomplished using cell validation.
0
votes
0answers
24 views

PreSaveAction not working for Page Layout Edit mode

I have an article page where I need to do some custom validations in Edit mode(page layout). I tried with PreSaveAction method but I guess it only works for list forms. Any idea how I can validate few ...
0
votes
0answers
18 views

The security validation for this page is invalid - SharePoint 2013

I want to send email from modal, the problem is I´m getting security error saying: The security validation for this page is invalid The difference between me and another users, it´s that I do it in a ...
0
votes
1answer
27 views

How can I use JQuery to conditionally require the people picker field on edit form?

Environment: SharePoint 2013 foundation I'd like to make/validate the People Picker field required conditionally in the edit form of a task list. If the task status is changed to Completed, I want ...
1
vote
1answer
982 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
0answers
29 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 ...
3
votes
1answer
95 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 ...
0
votes
3answers
958 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
16 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
68 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
142 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
85 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
80 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
24 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
40 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
132 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
98 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
270 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
134 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
75 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
73 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
41 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
47 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
73 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
39 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
52 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
6k 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
38 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
176 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
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
228 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'...