General

Re: Cascading dropdowns with multiple data sources

heath3106 — Thu, 13 Aug 2020 17:42:15 GMT

Thankfully, I was able to figure it out. Your solution put me on the right direction. Thanks.

Re: Cascading dropdowns with multiple data sources

heath3106 — Thu, 13 Aug 2020 12:42:41 GMT

The filter is set up and the dropdown shows a set of rows, but they are all blank, no values.

Re: Cascading dropdowns with multiple data sources

heath3106 — Wed, 12 Aug 2020 19:44:24 GMT

So I think I have the filters set up correctly. However, dropdown 2 is not showing a list of values to choose from when I select the field.

Re: Cascading dropdowns with multiple data sources

Hilary Stoupa — Wed, 12 Aug 2020 18:35:22 GMT

It may be a little more complex than that - in the condition builder for the filter on drop down b, you'd select the abbreviation from B. Then is equal to and in the third dropdown, use a formula. In the formula, you'd pick the abbreviation from data source A and add a filter - in that filter, you'd select the region in data source A is equal to the selected region in the form. Hope that makes sense. :)

Re: Cascading dropdowns with multiple data sources

heath3106 — Wed, 12 Aug 2020 15:35:44 GMT

Does this look right for the filter? abbrev (a) is equal to abbrev b and Region (a) is equal to Region (form)

Re: Cascading dropdowns with multiple data sources

Hilary Stoupa — Wed, 12 Aug 2020 15:22:08 GMT

Does the data source for A contain the abbreviation? If so, this can be done, but the filter is a little more complex. When you add the filter to drop down B, you'll add a filter where the region abbreviation is equal to the region abbreviation in the data source for A where the full region name is equal to the region selected in the form. It sounds a lot more awful than it actually is - attach a copy of your form under the options tab in a reply if you'd like a hand. :)

Cascading dropdowns with multiple data sources

heath3106 — Wed, 12 Aug 2020 13:14:00 GMT

I have two tables - one for region and the other for site. The common data point is TCS (which is an abbreviation for Region) What I want to do is have dd B (site) give a limited number of choices based on dd A (region). dd A selections are the full region name and not the abbreviation. How do I accomplish this?

thanks for the help.