I'm having problems performing form-level validation using the Validation on Submit Rules and am hoping someone has solved this and can offer advice.
I have two fields - a Wage Type and a Wage Amount. I want two rules that say something along the lines of:
If Wage Type = Hourly and Wage Amount > $50, then throw an error message that stops the form being submitted.
If Wage Type = Salary and Wage Amount > $100,000, then throw an error message that stops the form being submitted.
I can see how a simple rule will work, but I can't get these working because of the AND. If I could set the rules to test for the error condition, it would work, but the way Validation on Submit works I have to test for a valid condition and the message is thrown when the condition is false.
I tried using Rules on the Wage Amount fields, and they throw the error messages correctly, but it didn't stop you from acknowledging the message and just hitting Submit, hence my trying the Form-level Rules.
Any help appreciated.