Skip to main content
Question

Possible Formula help

  • October 25, 2023
  • 0 replies
  • 23 views

Forum|alt.badge.img+8

I have a field that I would like to set up if certain selections are made then I want the field below it to only populate the additional options based off of that selection. I would like to do this without creating multiple fields for the selection categories and not have to use a dynamic rule. 

    is it possible to set up 2 fields to interact this way without using a dynamic rule?



    ------------------------------
    LB
    ------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • Quickbase Alumni
    • October 25, 2023

    Quickbase supports a conditional drop dow where be list of choices offered when selecting a related parent is conditional on a matching value previously selected.

     

    For example:  Set up a table of Car Models with two fields being Make and Model and load it up with these pairs

    GM Blazer

    GM Chevy Bolt

    GM Cadillac

    Toyoto RAV 4

    Toyota Corolla

    This table will be the parent in the relationship to select the field with will be conditioned on a previous choice.

    So on your detail records you would select say GM from a list of Makes, and then set the field properties for the field for Related Model to be conditional on the Make,  so that once you select GM you'll only see three choices offered. 

    .

    Then on he 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------