On a recent project of ours, we were given a requirement in which we needed to have about 20 items to be true before the form could be submitted. Looking at the validation box we can only have a maximum 5 conditions.
One of the greatest functions of the data validation tool though is to create a custom condition by an expression. For complicated validation requirements, this is often the fastest way to create your condition. To find out the syntax, select what you want in the row. In this case I will say that the data validation error will come up if field 1 is not equal to "bob"
The next step is to change the first drop down box to "The Expression" rather than the field.
As you can see, the expression box automatically converts the condition to the appropriate format. We can then add Boolean operators (and, or) to chain these together as well as parentheses to nest them. Using notepad and copy / paste I was able to create a very large string which held all 20 of my conditions.
