Discussions

 View Only
  • 1.  Only show checkbox fields that are checked after saving record

    Posted 09-21-2017 19:33
    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. 


  • 2.  RE: Only show checkbox fields that are checked after saving record

    Posted 09-21-2017 19:57

    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].




  • 3.  RE: Only show checkbox fields that are checked after saving record

    Posted 09-27-2017 17:03
    I have 300 of these fields. I would have to go line by line and create 300 rules?


  • 4.  RE: Only show checkbox fields that are checked after saving record

    Posted 09-21-2017 20:51
    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.


  • 5.  RE: Only show checkbox fields that are checked after saving record

    Posted 09-22-2017 00:49
    Curious... How many checkboxes are we talking about?

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

    Or a child table?


  • 6.  RE: Only show checkbox fields that are checked after saving record

    Posted 09-27-2017 17:01
    The options have waaayyy more than the 40 character limit for multi-select. I wish that limit would go away.