Change multiple drop down options based on another drop down

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have multiple drop down options on my form (dropdown A, dropdown B, dropdown C). I want to filter the choices from these dropdowns base on the option selected on the main dropdown (dropdown X). Is there a possible solution for this without using conditional drop down (2 tables)? Thank you for the answer.

Photo of Ruben

Ruben

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Scott

Scott

  • 334 Points 250 badge 2x thumb
Hi Ruben,

Off the top of my head, there is no way to do what you would like without conditional dropdown, which like you said, would require two tables.  

However, there is an overly-complicated work-a-round which I would use if I was in a situation where this is a MUST HAVE.. Here's an example:

Dropdown X has three choices.  You will need to create dropdown A1, dropdown A2, dropdown A3, dropdown B1, etc..


A1, B1 & C1 correlates with choice #1 in dropdown X.  A2, B2 & C2 correlate to choice #2.  Etc.

On the form where users will be entering this (edit), you will make a few rules, where if dropdownX = choice 1 then display A1, B1 & C1.  You'd have to do this for all dropdown X choices.  

Lastly if you need to read the results of dropdown A, B, C, in another formula, you'll probably want the results of each (dropdown a1, a2, a3) to merge into a single field.  So we'd create a "Dropdown A*" field which would read something like...

If([Dropdown X]="choice 1",[dropdown a1],if([Dropdown X]="choice 2",[dropdown a2],if([dropdown x]="choice 3",[dropdown a3],null)))

Again, you'd have to do the above for each dropdown A, B and C.  Then on the form for VIEWING you can have dropdown A*, dropdown B*, and dropdown C* show.  (Then on the edit form, you have the if dropdown x trickery using rules that I explained above).



This is my over-complicated workaround to conditional dropdowns if you absolutely do not want to have another table.  YES its complicated.  YES its impractical.  YES there's probably a better way of doing things.  But nobody has yet offered a better solution and this is all I know.



Scott