Multiple list validations..... is it possible??

Question

_{Friday, April 26, 2013 12:00 PM}

Hello,

I am using Sharepoint 2010.  I have been looking at the column and list validations but noticed that it seems I am only able to create one list valdiation because there is only one place to put a list validation message if the validation fails.  I have three separate validations I would like to do.  They all involve multiple columns so I need to use the list validation rather than the column validation.  Is it possible to have multiple list validations where I can have multiple formulas and a message for each of them?  I can't find a way to do that within the list validation screen but I could be missing something.

Thanks - Peter

All replies (4)

_{Friday, April 26, 2013 12:31 PM}

Sjoerd,

Thanks for the reply.  Maybe you didn't understand my posting but I am having to look at the List validation because I know that I can't use the column validation due to column validations not being able to look at other columns.  The question is whether I can do multiple independent validations in the List validation.

- Peter

_{Friday, April 26, 2013 1:06 PM}

Sjoerd,

I am not sure where the confusion is.  I realize that you can have a compound formula to do multiple checks, but my question deals with how to have multiple "independent" formulas that can have there own message if it fails.  I only see one box for a single message to report a failure, so it doesn't do any good to have a compund formula checking various things if the message needs to be different based on which ones fail.  For example, if I have FieldA that needs to have a value if FieldB has a value.  If that is all I needed to validate, then I would be good because that is a single validation.  But what if there is a second independent validation that says if FieldC > 100 then FieldD needs to have a date.  Now I have two separate independent validations that I need to do which require different messages if they fail.  I am trying to find out if I can have multiple formulas that can have their own message if a failure occurs.

- Peter

_{Friday, April 26, 2013 1:44 PM}

I suppose it is not possible to have multiple list validation messages..
it would be better if u do event receivers and put the condition there.

hope this helps

_{Friday, April 26, 2013 2:08 PM}

Okay, thanks guys.  I figured that would be the case but I was hoping that I was just missing how to do it.