Clear checkboxes when value of other field changes

[jmendel]

I need a script that will clear all checkboxes (set field to"") when a user changes the value of another field. The value in that field is changed using a pop-up menu so the script trigger would have to occur once the selction is made.

Example:

1. (Field:Select_Body_Trim) = ZX5 SES

(Field:FTDC) = 1 (checkbox contains "X")

2. User enters Field:Select_Body_Trim and changes value to ZX4 ST using the pop-up menu.

3. New script will set Field:FTDC to "" (checkbox un-checked)

[Rowley]

Ummm... couldn't you do that using the "Clear" script command?

[jmendel]

I don't know, that's why I'm asking. Can this script be triggered when a pop-up menu selection is made? As soon as I try to set that to happen, I lose the ability to use the field as a pop-up menu. It changes to a button effectively.

[Ender]

Try making the checkbox field's definition an auto-entered calc with the do not replace existing values option off. The calc would be something like this (I can't test it right now):

FTDC (text, auto entered calc) = if(isempty(Select_Body_Trim); FTDC; "")

When a selection in the Select_Body_Trim field is made, the checkbox is set to "".

[Ender]

Oops, it looks like that checkbox supposed to get cleared whenever the Select_Body_Trim field is changed. An auto entered calc may still work if it's comparing Select_Body_Trim with its previous value, but I can't try it now.