Apply show/hide rules to a field on a form, based on THAT field's value.
if you are using a form to only view data, or if a form includes data that is read-only anyways, it would be nice to have the option to show/hide that field based on whether or not it has a value in it. This ensures that data will only be displayed when data is actually present.
Anonymous
shared this idea
1 comment
-
John McGarvey
commented
I like this idea, but it can be done today with a bit of work.
1. Create a calculated field to check if the field to be hidden is populated or not. I use a calculated number field: If(isblank(FIeld To Hide), 1, 0).
2. Create a new Field Section on your form and add the calculated field.
3. Set a Show/Hide rule to hide this section. I use the auto number field, and only show this section if the the auto number is less than 0, which will never happen.
4. Set the Show/Hide rule for the field you want to hide, using the calculated field in the new section as your measurement. If the calculated field = 1, Hide, else Show.