Tag Info

New answers tagged

0

Why not use a regular expression instead? Wouldn't that be so much easier? http://www.jslab.dk/tools.regex.php


2

You can use following pattern try { item.Update(); } catch(SPListDataValidationException ex) { //ex.Message } https://msdn.microsoft.com/en-us/library/microsoft.sharepoint.splistdatavalidationexception_members(v=office.14).aspx


1

You can try below =IF(or(c1="choice2",c2="choice3"),isblank(c2),true) The logic is if c1 = choice2 or c2 = choice3 check if c2 is blank (if blank return false, else return true) else return true Update =IF(OR([column2]="pineapple",[column2]="apple"),IF(ISBLANK([simplelineoftext]),FALSE,TRUE),TRUE)


1

Try using below code if($("input[Id^='Title']").val().trim() == "") { bvalSubmit = false; }


0

I think your nested IF is missing the 3rd parameter that is causing the problem. You should use one of the following =IF([Food Service]=TRUE,IF([Food Service Type]="Please Select an Option", FALSE, TRUE),TRUE) Option suggested by Amal Shorter version: =NOT(AND([Food Service]=TRUE,[Food Service Type]="Please Select an Option"))


0

If it is Yes/No then you should validate against TRUE and FALSE So your formula will be =IF(AND([Food Service]=TRUE,[Food Service Type]="Please Select an Option"),FALSE,TRUE)


0

The formula will be long and there is no way to escape it. If possible you should do this in an event receiver. =IF(ISBLANK(f1),TRUE,IF(ISBLANK(f2),TRUE,IF(ISBLANK(f3),TRUE,IF(ISBLANK(f4),TRUE,IF((f1=f2)OR(f1=f3)OR(f1=f4)),TRUE,IF((f2=f3)OR(f2=f4),TRUE,IF(f3=f4,TRUE,FALSE))))))) The logic is a follows If any of the field is blank then return true else ...


3

Most probably this error occurs since locale for web site is set to non-default language (1033) and the incorrect delimiter is specified for a function (in your case the delimiter is ,) The delimiter in formula is language dependent. For example when web locale is set to 1035 (Finnish) then the proper syntax for formula is: =AND(ISERROR(FIND(" ...


0

As per my understanding there are two solutions to this 1. Using client side scripting In this case you should edit the new/edit form and add JavaScript which goes and check if FirstName + ' ' + LastName already exists in the list. For that you can use SPServices and then handle this validation on PreSaveAction method. This approach will provide a good ...


0

You can use IF as below IF(CODE(MID(BOPassword,11,1))<>33,IF(CODE(MID(BOPassword,11,1))<>64,IF(CODE(MID(BOPassword,11,1))<>36,IF(CODE(MID(BOPassword,11,1))<>42,IF(CODE(MID(BOPassword,11,1))<>43,0,1),1),1),1),1) The above will return 1 if position 11 contains any of code 33 or 64 or 36 or 42 or 43 else it return 0


1

A calculated column wont work they way you want it to. I would recommend to rather create a workflow which on save: If %complete = 100% { If date/time-column = empty { Set date/time-column to Changed (time/date) } }


0

Person & Group fields are complex fields. i.e they holds more information which you can treat as an object. Because of this these fields can't be used in a Formula (we can't specify which property of the object we should use (id/loginname/displayname/email) Work around Create an event receiver and do the validation in ItemAdding Create a workflow and ...


0

The solution is to move this formula validation from column level to list level. Thus all the columns are present at the list level.



Top 50 recent answers are included