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
3answers
213 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
0answers
97 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
112 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
58 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
103 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
991 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
84 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
20 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
176 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
64 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
58 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
2answers
32 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
52 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
173 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
186 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
54 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
2k 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: ...
3
votes
1answer
731 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 ...
3
votes
0answers
83 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
47 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
56 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
25 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 ...
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 ...
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 ...
0
votes
2answers
251 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 ...
1
vote
0answers
108 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
61 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
383 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
742 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
4k 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
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
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
712 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
63 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
33 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 ...
8
votes
5answers
4k views

How do I trigger the default form validation without submitting the form

I'm customizing the NewForm of a list item and need to trigger the default form validation from my JavaScript, but I don't want the form to be submitted, since I'm doing that in a callback later on. ...
1
vote
1answer
231 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
0answers
67 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
373 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 ...
2
votes
3answers
514 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 ...
1
vote
0answers
99 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 ...
2
votes
1answer
935 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
0answers
419 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
107 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
377 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
99 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. ...