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

5 Replies

Related Content

Autofill user field when a checkbox is checked

Concatenate A field based on if a checkbox is checked

Docusign checkbox fields

Rule If Checkbox1 is Checked then Uncheck Checkbox 2 not Working

Checkbox Formula - only pertinent records

Recent Discussions

Create a formula duration over 5 years

Time of Day field values are not in 24-hour format in Pipelines

Join multi-line text field to one line

Report for Expired Training Records

Formula URL - Edit then Add