Only show checkbox fields that are checked after saving record

Question

I have various fields on a form that are check boxes. I want to only show the fields that were 'checked' once the record is saved. Is there a way to do that? I do not want a report but rather make the unchecked fields disappear on the saved form.&nbsp;

chrischris · Answer

Hi StephonyThis is easily done with form rules. But you may want to have a separate form for viewing and one for&nbsp;adding/editing records.&nbsp;If you have access to building form rules, you'd enter a line of form rule logic in the view form that says. if [field] is unchecked, hide [field].

quickbasecoachd · Answer

Stephony,

I suggest a duplicate set of checkbox formula fields, just equal to each respective data entry field.

Then only show them in View mode and use a set of form rules to hide if they are blank. I think it�s best stick to just one form wherever possible.

mcfneil · Answer

Curious... How many checkboxes are we talking about?Any reason you can't use a "multi-select" field?Or a child table?

stephony_dbh_ · Answer

The options have waaayyy more than the 40 character limit for multi-select. I wish that limit would go away.&nbsp;

stephony_dbh_ · Answer

I have 300 of these fields. I would have to go line by line and create 300 rules?

Forum Discussion

Only show checkbox fields that are checked after saving record

Related Content

Add Numeric Fields together if a checkbox is checked

Checkbox Fields Vs Multi-Select Fields for Tracking

Autofill user field when a checkbox is checked

Check one field for multiple conditions

Combining AND with OR in Formula Checkbox Field