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
2answers
33 views

Validating Sharepoint Column doesnt contain word Sharepoint

I want to create a single line of text column that validates following items: Unique:can be done using OOB column settings 10 character: can be done OOB column settings All Lower Case: How do I do ...
0
votes
2answers
46 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 ...
2
votes
1answer
36 views

Show error message when custom Ribbon button is disabled

I have a custom button added to SharePoint Ribbon. And there is EnabledScript attribute of the CommandUIHandler for the button. This attribute contains a javascript code to conditionally ...
1
vote
1answer
3k 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 ...
1
vote
1answer
453 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 ...
1
vote
1answer
2k 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
22 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
1answer
39 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
16 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
1answer
33 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
101 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
30 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
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
36 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
1answer
1k 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
412 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
43 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
1answer
501 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
532 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
582 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 ...
2
votes
0answers
51 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 ...
2
votes
0answers
50 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 ...
1
vote
0answers
19 views

Person Is Valid SharePoint User [MultiUser]

I have a list with column named 'MultiUser' [DataType: Person or Group, Multiple Selection Yes] I want to validate all the Users in List using SharePoint Designer. I can do this if there is only one ...
1
vote
0answers
75 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 ...
1
vote
0answers
81 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
371 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" ...
1
vote
0answers
139 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 ...
1
vote
0answers
231 views

Validate list item with javascript API

I want to develop a custom datasheet view to edit a list. I add item through the javascript API. The problem is that the service doesn't control fields value. For example : - I add an item with a ...
0
votes
0answers
21 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
0answers
18 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
0answers
46 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
14 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
0answers
22 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
0answers
908 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
0answers
55 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
0answers
115 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 ...
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 ...