Skip to main content
Question

Conditional Drop Down with Duplicates

  • June 1, 2021
  • 0 replies
  • 65 views
Forum|alt.badge.img+9
I have been asked to restrict selections based on previous selections (typically a conditional drop down)  However choices are not unique.  

Choice 1: A or B
Choice 2: A or B
Choice 3: A or B
Choice 4: A, B, C or D

As an example:  If Choice 1=A, Choice2=B, Choice 3 should only allow for A and Choice 4 should only allow A & B ( I have been given an excel grid with all scenarios)

Updates will be made in Grid edit so cannot use form rules.  If I do go ahead with Conditional drop downs, will duplicate A & B's be needed to accommodate the Choices 2-4?  Thanks!!

------------------------------
Christine White
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+9
  • ChristineWhite
  • Author
  • Quickbase Alumni
  • June 1, 2021
Also wondering if there might be a way to build a look up table that can act as a filter to display the allowable choices

------------------------------
Christine White
------------------------------
Forum|alt.badge.img+9
  • ChristineWhite
  • Author
  • Quickbase Alumni
  • June 2, 2021
I just ended up creating a standard conditional dropdown, duplicating values in order to create all allowable combinations.

------------------------------
Christine White
------------------------------
Terms & ConditionsAccessibility statement