Only show checkbox fields that are checked after saving record

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
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. 
Photo of Stephony (DBH)

Stephony (DBH)

  • 586 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

Hi Stephony

This is easily done with form rules. But you may want to have a separate form for viewing and one for adding/editing records. 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].


Photo of Stephony (DBH)

Stephony (DBH)

  • 586 Points 500 badge 2x thumb
I have 300 of these fields. I would have to go line by line and create 300 rules?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,850 Points 50k badge 2x thumb
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.
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Curious... How many checkboxes are we talking about?

Any reason you can't use a "multi-select" field?

Or a child table?
(Edited)
Photo of Stephony (DBH)

Stephony (DBH)

  • 586 Points 500 badge 2x thumb
The options have waaayyy more than the 40 character limit for multi-select. I wish that limit would go away.