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
1answer
15 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
23 views

make something a required field depending on value

How can I make a column required depending on another columns value. Is it possible to do this without javascript?
0
votes
1answer
11 views

2 base items change the items in a form

Not really sure how to go about this, I want this vanilla sharepoint if possible. I have two 'Base Items' Player and Manager. These both have different forms. Some columns will be the same but some ...
0
votes
1answer
12 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 ...
0
votes
1answer
26 views

Recalculate Calculated Columns with Javascript

Has anyone some sample javascript code to recalculate a calculated column in SharePoint 2013 tasks? This should work on new and edit form and also with the AllItems view. Many thanks.
0
votes
1answer
22 views

change value of an item in validation

I am using list validation and I want to use an IF statement where is changes the value of a field. Say IF([column 1] >2, column2 = 'hello' If true, column3 = 'no' if false) Is this possible using ...
-1
votes
0answers
12 views

List Validation, if statement

I am trying to do list validation. I have a YES/NO checkbox. If that has been checked I want to input in another column(Column 1) the word YES and in another the date(Column 2). else change another ...
7
votes
2answers
166 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
1answer
65 views

Check for Valid User via Button

Ok, so I have a form that has multiple views, some read only and some editable. Each form has buttons to open the other forms in either edit mode or read only mode based on a field being set to ...
2
votes
0answers
27 views

how to validate fields with html5 & sharepoint 2010 webpart?

Recently, I tried to get validated fields with RegularExpressionValidator. When I deployed the webpart, the click event is not working as expected. I hear that RegularExpressionValidator is not ...
0
votes
2answers
57 views

Cannot save sharepoint page with my custom webpart (with asp.net validation controls)!

I am using sp2010. I have created a visual webpart in Visual Studio 2010. In this webpart I have created a sort of contact form with fields and a button. I have deployed this webpart to my sp site and ...
1
vote
3answers
64 views

Required attribute is ignored on Dropdown and Radio field

It seems that Site Columns defined as Type="Choice" ignore the Required="TRUE" attribute when it comes to form validation on the Edit/New pages. In this sceanrio, I chose to not define a default value ...
1
vote
0answers
42 views

SharePoint Custom Validation with ValidationFormula

I was wondering if there was a way to execute a validation using the SPField.ValidationFormula before you use SPListItem.Update(); I would like to know that a field is not valid before I execute ...
1
vote
1answer
281 views

Making Presaveaction() wait for SP.UI.ModalDialog response

I am using the Presaveaction() to perform pre-new/edit form validation. Once all fields have been validated successfully I would like to offer my users the ability to 'Save and Exit' or 'Save and ...
0
votes
0answers
37 views

Creating a Checksum/Hashcode for files for a comparison/validation after Migration?

I was wondering if anyone has stumbled upon or knows of a method on how to create a Checksum/Custom Hash for a file on MOSS 2007 or SP 2010 ? The problem I am having is that I am trying to validate ...
1
vote
0answers
143 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" ...
2
votes
2answers
49 views

Date Format Modifcation in List

I would like to format a new column with the Month and Day of another column. Is there a way to accomplish this? I tried adding this =TEXT([Date of Birth],"MM/DD") in column validation but it gives me ...
2
votes
1answer
129 views

Visual Web Part Property Validation in Sandbox Solution [SharePoint Online 2013]

How can I validate a custom web part property in a Sandbox solution (SharePoint Online 2013 environment)? I am throwing a WebPartPageUserException when validation fails, as shown below. private ...
0
votes
1answer
25 views

Nearest thing to allowing entry of text or date in list

I have a list which collects the dates that systems were lasted tested on. Ideally therefore, I would like it to be a date field. This way, SP uses built-in functionality to validate the entries. ...
2
votes
1answer
49 views

Are SharePoint versioning possible to validate according to Food Safety Standards?

Use Case: I often tell future customers that “Sure, you will have previous versions available for those with the right permissions”. While that is true, I wonder if I can get away with that statement ...
1
vote
1answer
57 views

Column Validation

I got 8 columns in my List(calendar reservation). I want to have one column(Approval: YES/NO) only visible to a user("testuser"). How can we use column validation *expressions* to archive this. ...
0
votes
3answers
48 views

IF Statement - may need re-writing

I am using an IF statement to allow both a-z and A-Z characters (shown below). +(IF(OR((AND(CODE(MID([Field],1,1))>64, CODE(MID([Field],1,1))<91)), (AND(CODE(MID([Field],1,1))>96, ...
2
votes
2answers
88 views

validation problem - I want to ignore validation if field is totally blank

We have a SharePoint List which has validation on it to check for a National Insurance number (9 characters long, 3 letters and 6 numbers). However, it's not a mandatory field, so we would also like ...
0
votes
1answer
168 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
2answers
979 views

sharepoint 2010 column validation syntax

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

How to validate text input in list is a multiple of 10

I am trying to use a text column, as opposed to a number column, as I don't want any of the number formatting that automatically comes with Sharepoint. I only want this column to accept multiples of ...
0
votes
2answers
79 views

Linked Field Validation

I have two fields within a list which should be dependent upon each other. When the user creates/edits a list item I need to ensure that if one of the two fields has a value then the other is ...
1
vote
1answer
288 views

Check for Validation Errors on Submit Button Click [closed]

I have an infopath 2010 form that already has some VB code behind it. I want to create a SubmitButton clicked event that checks for validation errors before it submits.. I have an example in C# and i ...
0
votes
3answers
1k views

Unable to validate sharepoint date time control

I have added a <SharePoint:DateTimeControl> in my visual web part and I want to make it mandatory. To do so I referred this link and used as per my code. My code is: <tr> <td> ...
1
vote
1answer
417 views

How to make taxonomy picker required when used in visual web part?

I have created a visual web part in which user has to specify a field's value from taxonomy picker control. I want to make that value mandatory. The control is placed successfully but when I use the ...
1
vote
1answer
2k views

List settings validation formula syntax

I have two columns within a custom list which are check boxes (yes/no). I need to ensure either one of those check boxes are selected so trying to utilize sharepoint validation settings. It seems like ...
0
votes
1answer
2k 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 ...
0
votes
1answer
35 views

ETA Field Validation

I have a list which has an ETA data/time control. I'm trying to figure out a way to prevent users from entering a date which is before the current date/time?
1
vote
1answer
167 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
68 views

list/column validation of user/group column in document set

I have a document set where there are columns (User/Group type) that I want to be optional upon the set's creation, however at a later time, based on the status of the set, they may become mandatory. ...
0
votes
1answer
614 views

Validation formula that TEXT should not to have SPACE

Is there any validation formula which don't allow to save some value in column with SPACE in SharePoint 2010? I know that is Calculate column formula with TRIM formula but I need to validation formula ...
0
votes
2answers
410 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 ...
1
vote
2answers
123 views

List validation on sharepoint 2010 list

I tried to add validation on sharepoint 2010 list to validate 4 columns but, the length of this validation is greater than length of text box to write the formula. Is there any way to expand this text ...
0
votes
0answers
108 views

Reading a specific image rendition programatically returns the original image

I've built a field type that inherits from RichImageField because I wanted to add validation on the width and height of the images referenced in that field. And it's working great. When I moved to ...
0
votes
0answers
140 views

validation user message is not shown

I've used the validation settings for my document set and it works fine but the problem is that instead of showing the "user message" this error message is appear in case of validation mistakes: ...
0
votes
1answer
283 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
692 views

TEXT formula does not work in SharePoint 2010

I try to find difference between two date and time value in SharePoint 2010. I have two common column (date and time) and I use this formula =TEXT(Column2-Column1,"h:mm:ss") but it does not work? I ...
0
votes
1answer
225 views

Calendar Column Validation for booking after a specific time

I'm trying to write a column validation for a SharePoint calendar to ensure all bookings are after 8.30am in the morning and before 5pm at night. I've tried the following: =AND(TIME(8,3,0) < ...
0
votes
2answers
149 views

Validat Data on Date And Time Column not work on editform.aspx on sps 2010

i have a pronlem on validation on edit mode of list items. my a simple list have a column named : "StartTime" with date & time type. and i add this validate rule : "=[Created]<[StartTime]" it ...
0
votes
1answer
138 views

Column validation on managed metadata term

I would like to validate when i create a new list item that the metadata item selected is a specific item and not a top level category for example in the above you should not be able to select ...
1
vote
4answers
798 views

How to perform date validation in publishing page layout?

I have the following 2 datetime fields which are used in my custom page layout on my publishing site. Basically, when a user is editing the page I want to validate that the 'NewsLiveDate' < ...
0
votes
1answer
225 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 ...
1
vote
1answer
1k 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
891 views

How to use Excel Functions IF and OR in SharePoint 2010?

I am trying to use multiple nested IF() functions combined with the OR() function in SharePoint 2010. In Excel 2010 it works very well, but it is not working inside SharePoint. I already tried to use ...
1
vote
1answer
519 views

List item validation using .NET Client Object Model

On a SharePoint Foundation 2010 installation, I have a list defined and have set some simple validation rules on a couple of the fields: Text field (required) Number field (required, min: 50, max: ...