SharePoint Stack Exchange
SharePoint Stack Exchange

Questions tagged [validation]

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.

431 questions
3
votes
3 answers

New Item form field validation in SharePoint

I have created a custom list with below two columns. 1. Choice with Yes/No values 2. Multiple lines of text In New Item form of this list, on click of save button I want to make field 2 mandatory only when "Yes" is checked in field 1. Please let me…
NotesArt
  • 557
  • 2
  • 9
  • 21
3
votes
1 answer

Sharepoint 2013 OOTB way to validate a "Yes" on Form Checkbox?

I have a checkbox on my form and do not want users to be able to submit the form unless it's checked. Under my List Settings > Validation Settings I'm using the formula: =[Acknowledgement]="Yes" but it returns the User Message validation error…
Maureen
  • 697
  • 1
  • 5
  • 23
3
votes
2 answers

Valdition Column Formula for Choices (Compelted, Not started, Inprogress)

In my Task list I got a column named "Status" with 5 different choices, Not Started In Progress Deferred Waiting on someone else Completed In my task, when it is set to Completed I want the Column status to show a picture. I've uploaded the…
Elinho
  • 121
  • 5
2
votes
2 answers

validation problem - I want to ignore validation if field is totally blank

We have a SharePoint List which has validation on it to check for a National Insurance number (9 characters long, 3 letters and 6 numbers). However, it's not a mandatory field, so we would also like to accept the form if the field is left totally…
Mark
  • 23
  • 3
2
votes
1 answer

Multi column Validation

I am looking to use Column Validation. I have column 1(C1) as choices A or B, column 2(C2) as choices W, X, Y or Z. If C1 = A then C2 must = W but if C1 = B then C2 must not equal W. Is there way to do this using the Column Validation?
Andrew
  • 441
  • 4
  • 12
1
vote
1 answer

List settings validation formula syntax

I have two columns within a custom list which are check boxes (yes/no). I need to ensure either one of those check boxes are selected so trying to utilize sharepoint validation settings. It seems like a simple formula but it is not working for me,…
svs
  • 11
  • 1
  • 5
1
vote
1 answer

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 an error. My formula is: …
user15805
  • 11
  • 1
  • 2
1
vote
0 answers

Alert you must specify a value for this required field alert in newform.aspx

I just added this code to trigger an alert on newForm.aspx. Unfortunately, after I applied this code Formula column Validation, my form is not working. Any solution? Formula column validation is not working when below code was applied.
Ameenah Alley
  • 11
  • 1
1
vote
1 answer

Online, JSOM, Add new Choice value to Lookup dropdown - cannot save form, "Invalid postback or callback argument. "

I had a code that dynamically creates items and adds them as lookup values. I used CSR but CSR is unavailable on calendar forms (EditForm/NewForm.aspx), so I try to re-write it to vanilla javascript. I have some form with lookup field pointed to…
Gennady G
  • 1,623
  • 3
  • 22
  • 35
1
vote
0 answers

need additional validation

I am looking for a simple way to perform an input validation or input control in newdocset.aspx. I need to avoid any “.” (dot) in the name to avoid a later performed path generation. I have tried with JavaScript so far but this seems to be the…
dam0kles
  • 11
  • 1
1
vote
3 answers

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. =IF(AND([Status]='Closed',(NOT(ISBLANK([Actual Date of…
TehSkrunch
  • 11
  • 1
  • 1
  • 2
1
vote
1 answer

Column Validation in SharePoint 2010

I have three columns, "Status", "Request Date" and "Completion Date". I want to do two things: If "Status" is Closed or Withdrawn, I need to add validation to have the user enter a completion date if the completion date field is blank. The…
user2811
1
vote
2 answers

SP2010, how to add email address validation to a column?

I have the following code: =ISNUMBER(FIND("@";[emailAddressField])) It's not working, can someone recommend a better formula. Thank you! The exact problem is... depending on the default site language the ; character needs to at times be , while at…
user879
  • 1,066
  • 6
  • 23
  • 47
0
votes
1 answer

Calendar Column Validation for booking after a specific time

I'm trying to write a column validation for a SharePoint calendar to ensure all bookings are after 8.30am in the morning and before 5pm at night. I've tried the following: =AND(TIME(8,3,0) < [StartTime], TIME(17,0,0) > [StartTime]) But it doesn't…
Averenix
  • 365
  • 3
  • 16
0
votes
2 answers

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 sure how to actually bypass the validations. Thanks!
thomas
  • 71
  • 1
  • 2
  • 7
1
2 3