Forum Discussion

PeterKrasznekew's avatar
PeterKrasznekew
Qrew Trainee
4 years ago

Creating multiple choice field that filters inputs based on input of another field.

Hello all,

     I am trying to create a field that filters inputs based on the input of another field. I currently only have one table in the app. I've tried to locate conditional formatting but I'm not sure if the issue is I only have one table and need to add a second with the relationships present. 

     Example:

      Field 1 Input "A" then options in Field 2 are 1,3,5
      Field 1 Input "B" then options in Field 2 are 2,4,6  

Thanks in advance for any input.

------------------------------
Peter Krasznekewicz
------------------------------

1 Reply

  • If data entry is on a form and not by grid edit, the easiest to do this is to have Three fields for Field 2.

    one will be call [Field 2 for A] with it's choices
    the other will be called [Field 2 for B] with its choices.
    Those two will show in Edit / Add  mode on the form.

    Then in View mode show a formula field called [Field 2]

    Case({field1],
    "A", [Field 2 for A],
    "B", [Field 2 for B])


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------