Filter based on a control that is also a filter based on another control

1

Hello!

I have a list of devices with corresponding operating systems (devices have multiple entires- one for each OS supported). I also have a list of app versions that are supported on certain OSes on certain devices.

I have a control (multiple select) that has a list of devices (filter_device). I then made a control (mult select) of operating systems that filters based on the device selected (filter_OS). So if I choose iPhone for filter_device, only the iOS versions are listed in filter_OS.

I have a table with device, os, app version all listed. I am able to filter the table based on filter_device without any issue. The issue I am having is filtering a table based on filter_OS. I don’t think it likes that I am trying to filter on something that already is a filtering control.

Any ideas? I like the idea of filter_OS only showing the relevant OS versions, but then I cant use that control as a filter for my table, which I need.

2

@Catherine_Infantolino

I’ve built some complex filtering systems, so I’m confident that what you want is doable. If you want to share your doc or a mocked up sample doc, I’ll jump in and take a look at it.

3

Hi!

I need your email in order to give you access because of the permissions we have set up.

4

@Catherine_Infantolino

What formula are you using for this?

5

11%20AM
Screen Shot 2019-02-21 at 10.08.11 AM.png1158×504 48.6 KB

6

54%20AM
Screen Shot 2019-02-21 at 10.08.54 AM.png1252×530 14.4 KB

7

@Catherine_Infantolino

Let’s start with this:

The [OS] column Select list formula returns columns:
[all devices/OS].[Operating Systems]

The filter_OS returns rows:
filter([all devices/OS],Device.Contains(filter_device))

The table filter condition is trying to match columns to rows (apples to oranges):
Matches(OS, filter_OS)

Try changing the [OS] column Select list formula to:
[all devices/OS]

This should match rows to rows (apples to apples).

1 Like
8

Doesn’t seem to change anything.

9

So it is working now but it doesnt seem to recognize the data from my master tables as the same values in the drop down. I am manually fixing that now

10

This helped. Thanks!

1 Like