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
236 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
56 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
316 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
1answer
603 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
2answers
3k 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
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
612 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
54 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
31 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
646 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
611 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
312 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
693 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
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 ...
0
votes
0answers
91 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
310 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
76 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 ...