Using checkbox to hide/show values

[gem28]

Hi!
I've been trying to create a formula that will hide text fields when values in a checkbox is selected.

The checkbox field contains 4 items. Each item corresponds to a text field. When items in the checkbox are selected, the corresponding text fields should display otherwise it should be hidden.

I used the formula below in the Hide-When box:
@If(@Contains (confidential;"A";"B";"C";"D") = 1; @False; @True)

The problem with it tho, is that when I select one of the items, all text fields get displayed.

Truly appreciate the help. Thanks!

Tin

 

[pmonett]

First of all, if your text fields are on the same line, this won't work. If you have to present the fields on a single line, you'll have to create a table with 4 cells and put one field per cell.

Second, for a checkbox field (or radio button, or dialog box), if you want the document to react dynamically, you have to activate (in the field properties) the "refresh fields on keyword change" option in the second tab of the field properties dialog box.

Last, but not least, you will need one Hide/When per field :

@If(@Contains(confidential;"A");@true;@false)

Hope this helps !

Pascal.


I've got nothing to hide, and I'd very much like to keep that away from prying eyes.

 

[gem28]

Thanks Pascal!

The program is working now. I was able to get an idea from the formula you suggested but I twicked it a little more.

It was not working while pointing at the checkbox itself so I created a computed text field with multiple values property. This field points at the checkbox field then hid it.

As for the text field, I made it point to the new computed field and used this formula:
@If(!@Contains (conf;"1");@True; @False)

Thanks so much for tirelessly helping! God bless!

tin

 

[pmonett]

Always happy to be of use !




I've got nothing to hide, and I'd very much like to keep that away from prying eyes.