Jump to content

Field Visibility Using Checkbox

This topic is 6167 days old. Please don't post here. Open a new topic instead.

Recommended Posts


Have a field that uses a checkbox value list. There are nine values listed. I am using the JMO visibility trick to show and hide another field. When I check a box I want the other field to show. Uncheck = no show. Works well when I check one box but not multiple boxes.

Value 1 Checked and Other field Visible.

Value 1 Checked and any other Value checked Not Visible.

I have 9 values in the ValueList and 9 Fields I want to show or hide depending on the check box. If 4 boxes checked = 4 fields visible. I know it has to do with the calc but can’t figure it out. I have tried both the case and if functions. Both work with one box checked but not multiple.

Any ideas greatly appreciated.

Link to comment
Share on other sites

The secret of the trick is that when you check the checkbox, you have "completed" the relationship to the portal that is used to show/hide the field.

I think that you cannot use a value list displayed as checkboxes. I think that you need separate fields for each checkbox, and separate portals for each field that you wish to show/hide.

I'd define my checkboxes as flag fields, that is, flag_Field1 type number. I'd put it on my layout formatted as a checkbox. I'd assign the value list "1/0" which contains 1 and a 0 (separated by carriage returns). Resize the checkbox to show only the first box (the 1). Hide the 1 by formatting the text of the checkbox to the layout background color. Put any label you want next to the checkbox.

The relationship to the portal will include this flag field. (You'll have a separate relationship for each of the nine values).

Btw, this really is a lot of overhead. I know this is neat, but reconsider if it's really helping achieve accurate data entry (the goal, I assume).

Link to comment
Share on other sites

  • 2 weeks later...

This topic is 6167 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.