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

Question

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

MarkShnierYou · Answer

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

Sign up

Login to the community