Block/enable a field, depending on another field

[alain delcourt]

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!

[Razumovsky]

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.

[jasonwood]

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.

[Ugo DI LUCA]

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

[alain delcourt]

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.

[Razumovsky]

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.

[alain delcourt]

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.