Discussions

Expand all | Collapse all

How do I display a form based on a field selection?

  • 1.  How do I display a form based on a field selection?

    Posted 04-04-2017 21:47
    I have 10 fields I'd like to capture in a record, but not all 10 fields are relevant for every record. Based on the value the user selects for the first field, I'd like to display a different subset of the remaining 9 fields to the user.

    I see there are solutions based on code, but I'm not sure where to enter the code. If there's a solution that's available through the QuickBase UI, that would be preferable.

    I also looked at dynamic forms functionality (with rules), but if I have fields that are used commonly across different forms, it seems I have to duplicate these fields, one for each section.

    Any suggestions? Thanks.


  • 2.  RE: How do I display a form based on a field selection?

    Posted 04-04-2017 21:52
    No problem.

    Make 10 form rules, one for each of the 10 fields. . Have each form rule just deal with whether to show or hide just one of the respective 10 fields.


  • 3.  RE: How do I display a form based on a field selection?

    Posted 04-04-2017 22:33
    Thank you! That works.