Refine Dropdown choices based on Variable (Data Master-populated dropdown)?

Benja shared this question 11 months ago
Answered

Hi,


Is is possible to have conditional/dependent/linked dropdown that is based on a Data Master?


I saw the tutorials and posts about creating a linked dropdown, but that just describes hard-coding the values and brute forcing the trimming by if/then/else statements.


I also saw how to trim Data Masters list/grid views dynamically based on user's selection.


However, I need to let the user select from one drop down, and then based on their selection, offer choices in the second dropdown that match on a given field in the second..


I figured out how to save the selection from dropdown #1 to a variable, but there doesn't seem to be any way to use that to filter the items sown in dropdown #2.


Hoping I'm missing something obvious?


Any ideas greatly appreciated!!


Best,

:)Ben


Example:


Data Master #1:

Condition_ID

--------------

Condition1

Condition2

Condition3


Data Master #2:

Condition_ID, Symptom_ID

--------------

Condition1, Symptom1

Condition1, Symptom2

Condition1, Symptom3

Condition2, Symptom1

Condition2, Symptom1

Condition3, Symptom1

Condition3, Symptom2

Condition3, Symptom3

Condition3, Symptom4


  • Dropdown #1: Offers all items in Data Master #1
  • Dropdown #2: Offers nothing until something selected.
  • Users Selects "Condition3"
  • Dropdown #2: Refreshes to offer: Symptom1, Symptom2, Symptom3, Symptom4

Comments (3)

photo
1

Hi there,

Yes you can. The key is using categories at the properties of a DataMaster. The following example should help.

Kindly let me know how it goes.

Best,

Sonia Durán

photo
2

Worked like a charm; thanks again!


:)Ben

photo
photo
1

Thanks, Sonia! Will give that a shot now.


Cheers,

:)Ben