The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group
Filter a dropdown/lookup using another dropdown/lookup
Hopefully someone has tried this before and figured it out...
I have a form that we'll call "company" with a field called "company name"
I have another form that we'll call "employee" with a field "employee name" and a lookup field to "company name" from the company form.
On my main form I want to have the user select "company name" from a dropdown and then select "employee name" from a dropdown but have the employee list filtered to just the employees for the selected company. The samples provided in the docs require all of the data to be in the same form but that structure doesn't work for me.
July 2, 2018 at 9:36 am
Nevermind!
I found this article....
https://formidableforms.com/knowledgebase/dynamic/#kb-set-up-cascading-fields
The documentation is not clear but this method not only controls display of the field but also filters the dropdown options at the same time. It's a bit confusing because the conditional logic seems to be designed to only control whether a field is shown or not but this does in fact also filter the options when a relationship exists. Just make sure you use Dynamic and not lookup fields and this will work.
Discussion closed.