Validation Types

[Lorie]

I have a form where I need to ensure the following:

 

if MaxCapacity is entered then MinCharge must also be entered and vice versa if MinCharge is entered then MaxCapacity must be enterd, is there a way to do this ? I'm thinking I will have to write a custom validator right? But not sure what I would put inside the validator...

 

Lorie

[Jeff Johnston]

You might be able to do some client side validation to do this as JMesa uses the bassistance jQuery plugin. I have not created any real custom plugins myself though so I am not sure what the limitiations are. Also, because the worksheet only captures the changes you would not need to be able to do server side validation for this because you would not have access to the previous or next column.

http://code.google.com/p/jmesa/wiki/WorksheetAddRemoveValidateRowsV3

In general I want to revisit the error handling of the worksheet. What we have seems to work ok, but it is pretty simple. I am starting a project that will be using JMesa's worksheet heavily so I hope to be able to power use this more now.

-Jeff