I have a template with 4 Yes/No pick list fields.  At least one of these fields should be answered with a "Yes" value before submitting the request.  Each field is mandated, but a user could still pick a "No" value for each and try to submit the request.

I can use a script on an "On Form Submit" Field & Form Rule to pop up an alert saying that a "Yes" needs to be put in somewhere, but how to then stop the request from being submitted?

I'm toying with the idea of creating another field, setting it to Mandated, maybe hidden/disabled to the requester, that would only be populated by another F&F rule if at least one "Yes" was selected.  Thinking the request wouldn't get created if that field was still empty.  But I'm not sure whether that would actually work, it may not be especially user friendly, and it certainly seems like a roundabout way of getting this done.

Any suggestions?  (Am I overlooking anything obvious?)

-- Russ

9.3 Build 9335

MS SQL