Upvote 1

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

Answered Benja ● ago

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

Replies (4)

Sonia Durán ●

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

Files:

Benja ●

Worked like a charm; thanks again!

:)Ben

Benja ●

Thanks, Sonia! Will give that a shot now.

Cheers,

:)Ben

Vinfrescos ●

I am unable to do this in the latest version I downloaded yesterday :(

very frustrating. I just can't find my way around this

I first added 3 fields A, B, C

Then tried adding values A1, from the VIew and Edit Records Tab manually. it would only give me a blank dropdown and I wasn't able to update the values

I tried importing values for 3 fields as text first and then converting the Type to Category. but it ended up populating blank values for all rows again with blank dropdown

Danielle Schneider ●

Would you mind attaching an example of a prototype the way you're doing it?

Guido Kuth ●

Doesn't work for me. The problem is that I can't use category field type in data-master, cause the values of the field must be editable in another dialog and data-master-category-type fields are not editable.

What I want to do is set and filter the content of the Category Control on the fly.

Nelson nymendaros@gmail.com ●

Hi, were you able to solve your issue? I have similar problem. I'm working on a search page with grid display and dropdown, date and radio button fields as search inputs. I want the dropdown and date fields value to filter distinct values from the data masters filed. I hope this is possible.