Jump to content
Sign in to follow this  
Fred in Thailand

Field Visibility Using Checkbox

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.

Share this post

Link to post
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).

Share this post

Link to post
Share on other sites

Hello and thank you in advance...

Can you please point me to a place I can research the trick to which you are referring?


Edited by Guest

Share this post

Link to post
Share on other sites

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
Sign in to follow this  


Important Information

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