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
1answer
25 views

how to get Relative Url using Jquery in Sharepoint Site?

in my sharepoint site first i want to get Host URL(/Site URL ),and user enter Relative URL in TextBox then i want to append that relative url with Host Url Using JQuery and nedd to check that url ...
0
votes
1answer
21 views

Validation upon initial entry

I have a new SharePoint list in which the user enters an item number along with other information. Is it possible to check the item number for all other item numbers in the past 7 days. If it exists, ...
0
votes
1answer
13 views

Data Validation

I have a list in SharePoint. It collects the date it was entered and then a Dynamic Column called Days in House. This column should update by subtracting the creation date from today's date and ...
0
votes
1answer
29 views

Validation on a list using IF, AND and ISBLANK

Im trying to validate my list in SharePoint 2010, so that it will only proceed when a column = xyz and a date column is not empty. I took a stab at the syntax and came up with this. ...
0
votes
1answer
25 views

How to specify a specific range of dates

I have a List that tracks certificates. I need to limit two of the input fields and I'm not sure how. I have a formula (=[Expiration Date]>[Last updated]) in place that prohibits an Expiration ...
0
votes
2answers
27 views

Validating Password based on nested IFstatements and FIND function Problem

I am having trouble figuring out how to validate multiple special characters in SharePoint 2010 when a user inputs a password. The special characters that are allowed are: !@$*#%&^)+ . When i have ...
1
vote
1answer
47 views

c# - how to validate sharepoint list column against ValidationFormula programmatically

I need to validate a string that user submit against SPField.ValidationFormula while adding new record to custom list in c#. Line to add new record is SPListItem item = mylist.Items.Add(); I have ...
0
votes
1answer
21 views

Help with list validation please

I'm trying to do a validation in one of our list. Basically, I have a Drop Down box with 5 choices (let's say choice1 to choice5). If choice2 OR choice3 is choosen, I'd like to have a mandatory ...
0
votes
1answer
27 views

Change in jQuery code from SharePoint 2010 to SharePoint 2013

I'm migrating a SharePoint 2010 VS project to SharePoint 2013. The project has custom list definitions and custom add, edit and view forms and uses jQuery 1.8.3. In 2010 the following code works fine: ...
0
votes
2answers
26 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 ...
1
vote
1answer
8 views

column validation syntax

Trying to compare 4 fields (only if populated) against one another so that no data is duplicated? I've tried something like this but gets too long. =IF(LEN(f1=1), ...
0
votes
1answer
36 views

Email address validation error

I have an EMAIL column and added this validation code: =AND( ISERROR(FIND(" ", [EMAIL],1)), IF(ISERROR(FIND("@", [EMAIL],2)), FALSE, AND( ISERROR(FIND("@",[EMAIL], FIND("@", [EMAIL],2)+1)), ...
0
votes
1answer
35 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
33 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
24 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
39 views

Task %Complete calculated column show date/time

Im trying to create a calculated column to show completion date of a task based on %complete. So if the task has hit 100% then it should autofill a date/time value based on this percentage.
0
votes
1answer
49 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
33 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
36 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
25 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
31 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
53 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 ...
2
votes
1answer
65 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 ...
3
votes
4answers
160 views

Validate a column only on edit

I have a date field that's now allowed to be >=TODAY(). But this validation should only be run IF the field have been edited. The field is present in a form with other fields. And if any of these ...
0
votes
1answer
84 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
34 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
97 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 ...
1
vote
0answers
33 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
2answers
52 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
54 views

List Validation

In attached sharepoint list column "Status" Data Type is "Number", Column type is "Calculated", Formula :- =IF(NOT([Balance Qty]=0),"OPEN","CLOSED"). Here the requirment is if "PO Date" is not ...
1
vote
1answer
61 views

Validation formula on new items only

I'm using the following formula to prevent users from entering spaces on the article name field. =ISERROR(FIND(" ",ArticleName)) The problem is the users have already entered data in this field ...
0
votes
1answer
618 views

List Validation Settings - Multi Line formatted Columns Missing from Create Formula

I have a custom list in which some specific fields need to have additional validation which I am implementing through Validation Settings. However, on the Validation Settings page, when I go to ...
0
votes
0answers
69 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
16 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
76 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
44 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
45 views

validating textbox's value according to regional and language settings

I have created an application page which contains many textboxes some of them must accept only decimals (amount). Administrators can change the language and regional settings and some counries has ...
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
47 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
122 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 ...
3
votes
1answer
129 views

Survey, validate today's date question

We have a private survey. The date the survey was completed is to appear in an Exported Excel sheet. To do so, I have added a Date Field question in the survey named something like "Today's date" ...
0
votes
1answer
45 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 ...
1
vote
2answers
887 views

Insert a list item using REST form webpart: 403 error even when X-RequestDigest is present

I intend to insert a list item from the main page in intranet to a list hosted on another site collection. I made this simple HTML & JS to get it done, but I always get the 403 / FORBIDDEN error: ...
2
votes
1answer
498 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
61 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 ...
1
vote
1answer
41 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, ...
0
votes
1answer
41 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
27 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
19 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 ...