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
1k views

Disable/Bypass JavaScript Client Side Validation

Is there a way to entirely disable client side validation of list forms? Specifically the date field validation which occurs before the form is ever submitted. I have tried PreSaveAction() but not ...
0
votes
2answers
20 views

List Form Validation Logic Not Working as Expected

I'm trying to include Validation Settings for my List Form where I've got a column called Food Service and another column called Food Service Type, where Food Service is a "Yes/No" type column and ...
0
votes
1answer
23 views

Unique Validation on Calculated Column

I have 2 columns (first name and last name) in a SharePoint custom list. I have a calculated column called "full name" just concatenates the first and last name columns. Due to requirements, I need ...
0
votes
1answer
19 views

Column Validation Forumla Question Regarding Special Characters and ASCII

I've run in a problem writing a formula that will basically validate what the user enters. So for example, i need a user to input a password using the following criteria: 12 characters long 1st ...
0
votes
0answers
13 views

Data Inputing in Multi-Line text box and specified type

Good Day all, Im new to sharepoint, I have been ask to test sharepoint to see if it would do what we need, in terms of data inputing for our specific data model. The input is important as we need to ...
0
votes
1answer
27 views

Person Group type column not listed on a custom list's Validation Settings page

I have a Person Group type site column that I am using in a custom list through content types. On the Validation Settings page of the list I cannot find that column listed in the selection list of ...
0
votes
0answers
24 views

SPUtility.ValidateFormDigest breaks ASP.Net server side validation

I have a Web Part which is using SPSecurity.RunWithElevatedPrivileges, and thus needs to call SPUtility.ValidateFormDigest. However, this apparently causes it to ignore all ASP.Net validators server ...
0
votes
1answer
33 views

ValidationFormula to include 2 datetime fields

I have a custom list which is created via code. It has 2 fields for start and end date. When I specify the ValidationFormula with the 2 fields, the code errors out. Is there a way to validate the 2 ...
0
votes
0answers
14 views

MAC input validation in SharePoint 2010 list

I would like to validate the input of a MAC address in a list and have gotten the formula 90% there. The final step that I'd like to accomplish is to set any upper-case characters to lower. I know ...
0
votes
1answer
30 views

How to validate on an absolute date?

I have a datetime field named "Date", and would like to only allow values within a specific range, say March 2015 - June 2016. Is there an easy way to do this? This rather hard one doesn't trigger any ...
0
votes
0answers
40 views

Validate Google Re-Captcha Server Side (Sandboxed solution)

I tried validate google recaptcha at server side, and according it's documentation, I had to do a request to an address (https://www.google.com/recaptcha/api/siteverify), passing three parameters ...
0
votes
1answer
56 views

validate Unique users in 2 columns sharepoint List

I have a list which stores information about new sharepoint site requests. Where i have 2 fields (people and Groups) Primary Site Collection Admin Secondary Site Collection admin Both of this ...
0
votes
1answer
17 views

Document validity in sharepoint 2013

I have some documents which are valid only for 3 months. It consists of some tax rates.Is there any possibility to show that the uploaded document is valid only for 3 months and further it should be ...
0
votes
0answers
23 views

SP2013 Column Validation Length without spaces

I have a Column Title, and need to get its length but not counting any spaces. This is a test should give me the length of 11 With LEN I can get the length of a string, but with the spaces. After ...
0
votes
2answers
69 views

Why does this multi-field validation forumula work in Excel but not in SharePoint 2013?

Why does my simple formula work in Excel but not-work in SharePoint? Why does this formula... =IF([Request Type]="Review",(IF(ISBLANK([Request Date]),FALSE,TRUE)),TRUE) ...work in Excel but fail ...
0
votes
0answers
57 views

jQuery .validate - submit don't fire after error

Validation plugin works fine except following scenario: user click submit button while text box is empty, get error message, then fill text box and click button again. This time nothing happens. Any ...
0
votes
0answers
15 views

SP2010: Add validation to a wiki page

I have a table on my wiki page. Is it possible to validate the data in those tablecells?
0
votes
2answers
59 views

Column Validation for Choice column

I made a new required Choice column with these choices: "", "Yes", and "No". Is it possible to use the built-in Sharepoint 2010 Column Validation to validate that the user chose either "Yes" or "No"? ...
0
votes
1answer
40 views

Sharepoint Column Validation

Can someone kindly give a short explanation of how SharePoint column validation works. As I tried to validate one column I didn't know if its working or not coz I wasn't getting any error message or ...
0
votes
1answer
19 views

How to Determine if One or More Fields in Custom Edit Form have Validation Errors

So I have a DVWP with an Edit Form. The form uses jQuery tabs to organize the fields for the different roles that edit the item. I would like to show a message at the top of the form if at least one ...
0
votes
1answer
46 views

Basic List Validation

I need to have a list validation using SharePoint 2010. What I am looking for is something like this: if( ( A && B ) || C ) Where A, B and C are expressions. I have the first part, A ...
0
votes
1answer
112 views

How to validate SharePoint form field using regular expression?

I am using SharePoint form field. I used regular expression for allowing only numbers not less than zero, but it is allowing alphabets and throwing error if I enter number less than zero. function ...
0
votes
1answer
42 views

Give users specific options in a single line text field - Sharepoint 2010

I have a list with a single line text field - [title]. Due to users being difficult, I now need to tighten this field down and only allow them to enter certain options. I was trying to do this via ...
0
votes
1answer
37 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
0answers
23 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
18 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
989 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 ...
0
votes
1answer
40 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 ...
0
votes
2answers
178 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
50 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
262 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
986 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
1answer
257 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
67 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
2k 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
34 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
16 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
459 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
45 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
30 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 ...
0
votes
3answers
55 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, ...
0
votes
1answer
524 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
558 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
2answers
248 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
615 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
1k 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 ...
0
votes
0answers
90 views

Access parent field values from custom field definition

I've got a form that contains different custom fields. During vallidation of field1 I need to know the value of field2. Does anyone know how to access the field? Or perhabs it is possible to connect ...
0
votes
2answers
1k views

programmatically list validation

I'm looking for a way to implement programmatically vallidation for NewListItems/EditListItems. One way I found was: to use the ListEvents and Validate on ItemAdding / ItemEditing. But instead of a ...
0
votes
1answer
287 views

Regular expression for validating a SharePoint site address

I am trying validate an input from a text box and I want to make sure it is a well formed SharePoint address, e.g. http://site/ Does anyone have a regular expression that can do this or another method ...
0
votes
0answers
75 views

how to validate custom web part property? [duplicate]

Possible Duplicate: How to validate Web Part property value? below is a custom prop and a code that i am using for my custom web part, my question is, how to validate a custom web part and ...