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

Slack Signup
Newsletter Optin
Help Desk

Filter a dropdown/lookup using another dropdown/lookup

Labels

This Discussion is public

Notifications

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.

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.