AnsweredAssumed Answered

Restricting data entry in a field

Question asked by jeffd on Feb 4, 2009
Latest reply on Feb 4, 2009 by raybaudi

Title

Restricting data entry in a field

Post

During data entry into a record I require Field "#1" to equal  a simple "Yes" or "No" input. Then if field "#1" equals a "Yes" then I require the user to input a number > 0 into Field "#2".

If field "#1" equals a "No" then I want field "#2" to be empty.

Is there a simple method, by either a script or function or both, that I disallow entry into, blank out, or insert a "0" into Field "#2" If Field "#1" equals a "No"?

The way I have it now, the user can still put a number, other than "0", into Field "#2" even if Field "#2" is a "No"

Outcomes