justinmind-logo
 
Upvote 1

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

Answered Benja 6 years 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)
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

photo
1

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

photo
1

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

photo
photo
1

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.

photo
1

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.

photo
Leave a Comment
 
Attach a file