Hi,

I want to block or enable the fullfilling of a field, depending on the value of another one.

Example:

- If training = "done", then enable the field training_date to be fulfilled.

- If training = "to be scheduled", the field training_date must be blocked (the date has not been defined yet).

What is the best way to do it? Looking forward to any help. Thank you!

Havent tried this, but seems like the easiest way would be through define fields.

set field training_date to be validated by calc:

not training = "to be scheduled"

and have pop up message saying "Cannot enter a date for someone who needs to be scheduled" or something like that.

You could turn off "Allow entry into field" and then use a script to "Go to field"

The script would check if training="done" (or whatever) before it performs the "Go to field" script step. You could activate this from a button next to the field.

You could even place this button just behind the field. Just don't remember to use another layout for search.

Razumovsky,

I kept your solution. Thanks for your help. Thanks to everyone.

I have just substituted the formula:

not training = "to be scheduled"

by:

not training = "to be scheduled" or Isempty(training_date)

Otherwise, once the user chooses training = "to Be Scheduled" and types a date in the training_date field, he gets a warning message but doesn't have any way to exit, not even to erase the content of training_date.

Keep in mind, though, that this will not prevent someone from entering a date first, and then entering "to be scheduled" in training. If this is a possibility, the above scripting solutions would be much more secure.

Actually, you can ask the system to do the test on training_date when the user does his first action outside of the current layout - to do it, you must unclick "Validate only if field has been modified" on the "Specify calculation" window.