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
23 views

Form validate - New item

I have a list on Sharepoint, and when some user add a New item, I need to validate fields... I would like something in jQuery... something that if the field is not validated, it shows a msg error and ...
2
votes
0answers
20 views

How do you validate a column only if it's new item being added?

I recently added validation to a field which works great. =[Arrival Date]>=TODAY()-5 However, I ran into an issue when an employee is editing an older item to update the "Status" but it's not ...
0
votes
1answer
306 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
1answer
371 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?
1
vote
1answer
21 views

List Validation Settings

I am trying to create a list validation rule that works for more than 1 argument. I have 2 dates as input, DATE1 AND DATE2, and a third date which is used to check that the first 2 have not expired, ...
2
votes
2answers
298 views

Sharepoint multi-column validation

I've got a custom list that contains multi collumns. The validation is made by a custom contenttype. Now I want a combination of two columns to be unique. Until know I did not found a way to solve ...
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
10 views

List Validation Settings: Ignore case when finding word

I am validating a column to see if it contains blacklisted words. I want to capture the words whether they are upper case or lower case but I cannot seemed to find any solution on the internet. Does ...
0
votes
1answer
354 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 ...
0
votes
0answers
14 views

Validations for formField control

i have some FieldForm controls I need to validate. For example : Fieldname=quantity, for this I need to validate like quantity > 0, and for a SharePoint datetime control I need to validate that ...
0
votes
1answer
9 views

Is it possible to report an activity date and calculate which pay period it falls under in a bi-weekly schedule

I really have no idea how to address this. I am tasked with marking and developing a way to track late entries based on the created date of a list item, the reported activity date(date selector), and ...
0
votes
1answer
109 views

Conditionally hide/require form column based on radio buttons

I'm sure it's been asked a million times, but after hours of searching and messing around I have been unable to find a solution...Hopefully someone here can help me? I have a SharePoint list that has ...
1
vote
2answers
3k views

infopath > How to make sure there is an attachment

Creating a resume upload form where user must upload attachment. On submit button I want to disable submit button if attachments is not present? I added Attachments is not present and this seems to be ...
0
votes
2answers
56 views

String validation with variable length?

I am using SharePoint 2013 and I am trying to validate a field that has a variable starting length but a certain format. The format I am using is XXxx-123456. Where 123456 is any 6 digits and XXxx is ...
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
1answer
29 views

validation in sharepoint

I have a textbox field. I want to put a validator for the textbox that if it contain any special character in name then need to throw exception. Below is the code I used but not working. Please let me ...
1
vote
2answers
2k 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 ...
1
vote
0answers
31 views

column validation across survey questions

I want to validate responses to a question in a survey using information from a previous question and I just can't get the survey to take the validation formula. Basically: Q1 = How many hours do ...
0
votes
1answer
27 views

Validate entire column with condition

I have a list that has a column which is an integer. Is it possible when selecting a number to validate if this number has already been chosen in the list. For example List Title Order ...
0
votes
1answer
61 views

Infopath Form requires me to Submit twice due to Slow Validation

I have created an InfoPath form that is connected to a SharePoint list. Apparently you can't use the Developer option in InfoPath if it's a List Form (Stupid, but hey). Form Contents (in Order): 4 ...
0
votes
0answers
161 views

Column validation formula within and outside of a list

I used to have this problem some months ago using SharePoint 2010, now it's back (SP 2013). Unfortunately I cannot remember what my "solution" was back then. Anyway I would be very grateful for some ...
0
votes
2answers
354 views

Client side date validation in SharePoint List form using jquery

I want a validation for no past dates i.e something like StartDate>=Today Is this possible can anyone help? Thanks...
0
votes
1answer
45 views

SharePoint Column Formula Validation

I need to check if a column (type Number) is an Integer (no decimal). I added this formula to the list validation: =mod([MyField],1)=0 But I get this error: The formula contains a syntax error ...
0
votes
0answers
28 views

Web Page Security Validation

What's the "best practice" when it comes to the web page security validation expiration? We set ours at 55 minutes per web application. We have SharePoint 2010, Standard Edition.
0
votes
1answer
75 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
145 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
15 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
32 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
34 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
27 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
vote
1answer
550 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 ...
7
votes
2answers
763 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
105 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 ...
1
vote
3answers
120 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 ...
2
votes
0answers
42 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
123 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
0answers
62 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 ...
0
votes
0answers
82 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
266 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
57 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
167 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
26 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
51 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
61 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
51 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
103 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 ...
2
votes
1answer
476 views

dropdown box(sharepoint form field) validation sharepoint 2010

I have a sharepoint form field(look up field), a dropdown box in a list...below is the screen shot when i type into it it finds the name.. but when i type a text which is not present in the drop ...
0
votes
1answer
46 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
89 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
437 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 ...