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
2k 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
5k 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
266 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 ...
0
votes
1answer
43 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
0answers
112 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
74 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
450 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
1k 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
1k 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
917 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
1answer
17 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
35 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
72 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
36 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 ...
2
votes
1answer
1k 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 ...
1
vote
1answer
254 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
3answers
564 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
71 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
406 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
108 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
0answers
426 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
117 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
399 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
62 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
104 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
60 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
137 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 ...
3
votes
1answer
664 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
64 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
106 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
869 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 ...
1
vote
1answer
1k 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
3answers
4k 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
6k 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
59 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?
0
votes
1answer
2k 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
747 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
240 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
1answer
1k 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
2answers
373 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
362 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 ...
3
votes
1answer
3k views

How do I validate a selected “choice” field in a survey?

We've got SP2010 foundation, and the other limitation is that we do not have access to SPD or any of the programmatic ways of accomplishing this. I'm looking for information about how to set this up ...
1
vote
4answers
2k 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
0answers
2k 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
624 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: ...
0
votes
3answers
253 views

Check if a list has the expected structure?

I must use a list in a webpart and display some data/graph/etc based on the list content (notice: this is simplified, so please do not give it much importance). To be used the list must have a ...
4
votes
1answer
107 views

formula to limit date entries to specific month

In my "time off" custom list I have start date and end date. I want to make the user splits up the entries if the time off spans months. In other words if the entry starts Oct 25 and ends Nov 5 I want ...
0
votes
1answer
395 views

Server side validation if Javascript disabled on user's browser

I have developed a small form with 3 input type = text and one input type = submit button. The end user fills the form and submit it, but no data inserted into backend List. (probably empty form is ...
1
vote
0answers
175 views

Updating a value of any item in a list based on a selection of bool for one item - jQuery

So I hope this makes sense. I have a column within a list that I want to use as an active flag. There are 5 possible categories and for each category there can only be one active value. So I need some ...