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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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