2015
Feb
2
revised Validating Password based on nested IFstatements and FIND function Problem
added 10 characters in body
Feb
2
comment Validating Password based on nested IFstatements and FIND function Problem
Thank you for the link, i have already reviewed it but it doesn't like the syntax when i try using the FIND function in an OR statement
Feb
2
comment Validating Password based on nested IFstatements and FIND function Problem
I have little to no experience in Javascript or calling them using a Presavefunction in Sharepoint, much easier for me to write the formula in sharepoint
Jan
30
asked Validating Password based on nested IFstatements and FIND function Problem
Jan
19
awarded  Scholar
Jan
19
accepted Column Validation Forumla Question Regarding Special Characters and ASCII
Jan
16
comment Column Validation Forumla Question Regarding Special Characters and ASCII
It doesn't like the IF statement, I put it in as +IF(CODE(MID(BOPassword,11,1))<>33,1) and it accepts it but when I go to test it it comes back with a validation error. I've also tried +(IF(CODE(MID(BOPassword,11,1))<>33,1)) and +AND(IF(CODE(MID(BOPassword,11,1))<>33,1)) with no success
Jan
16
comment Column Validation Forumla Question Regarding Special Characters and ASCII
I appreciate you helping me through this process. I have tried everything and it still wont validate, I used numerous =24 =25 =26, I've used the AND and put in the IF statement in various places and it keeps throwing an error when I type in the password correctly. Any suggestions?
Jan
16
comment Column Validation Forumla Question Regarding Special Characters and ASCII
Please ignore my last statement. I was having a spacing issue in the syntax! So SP accepted my formula with my added =AND and your IF statements. Do you know if the last line (=24) would be =30? Is each If statement another +1 along with the =AND being +1?
Jan
16
comment Column Validation Forumla Question Regarding Special Characters and ASCII
I still can get SharePoint 2010 to accept the IF statement, I've used an =OR and a =AND to load in the IF Statement but it dislikes it each time :(
Jan
16
comment Column Validation Forumla Question Regarding Special Characters and ASCII
Thank for your prompt response. If I add this to my code do I need to input (after my last code for character 12) an AND= then put in your following if statements? SharePoint's formula and how it accepts syntax confused even after reading many guides. @Amal Hashim
Jan
15
awarded  Editor
Jan
15
revised Column Validation Forumla Question Regarding Special Characters and ASCII
edited body
Jan
15
awarded  Informed
Jan
15
asked Column Validation Forumla Question Regarding Special Characters and ASCII