Multiple Controls Issue with Table

[Dutch_Douglas_Byrd]

I am currently building a Wiki hub that utilizes a table to hold subpages. This table has a Text Control and a Multiple Select Control that I would like to be able to use to either search for subpages or even filter by category of page.

The formula that I used to implement this was:
thisRow.Category.Matches([Wiki Filter 2]) OR thisRow.Title.Matches([Wiki Search 2])

As of now the Text Control Works (which is labeled as “Wiki Search 2”) but the Multiple Select Control isn’t functioning (which is labeled as “Wiki Filter 2“)

Anyone have any suggestions?

Pictures below for reference of the situation…

[Diego_Delfino]

Hi, have you tried using .contains() instead of .matches() for the filter?

[Felipe_Arnhold]

Hi @Dutch_Douglas_Byrd

Can you confirm that the Category column and the Wiki Filter 2 options are the same type?
Matches should work on multiple select as well.

If Category is a relation column, and the Wiki Filter 2 contains text options, the filter will fail, since they are from different types.

[Dutch_Douglas_Byrd]

Hi @Felipe_Arnhold

Just double checked and the Wiki Filter 2 is referencing the Category Column (See first image below)

and the Category column is a select list column type.

[Felipe_Arnhold]

@Dutch_Douglas_Byrd

Just noticed. You need to do an AND not OR.

[Dutch_Douglas_Byrd]

@Felipe_Arnhold

When updating the OR to AND, that fixed the Wiki Filter 2 control!

I then used an if statement to say that when the Wiki Search 2 & Wiki Filter 2 are blank then populate all the rows! Here’s my final formula

Thanks for the help!

[Felipe_Arnhold]

@Dutch_Douglas_Byrd

Great that you were able to update the formula to include this behavior. If you don’t mind, here’s a more straightforward formula that does what you want, using only OR and AND.

([Wiki Filter 2].isBlank() OR [thisRow].[Category].Matches([Wiki Filter 2])) AND
([Wiki Search 2].isBlank() OR [thisRow].[Title].Matches([Wiki Search 2])

In the end, this is boolean logic.

So, if the Wiki Filter is blank, the first part will always return true and will include all rows. This means the filter will depend only on Wiki Search. The opposite is also true: if Wiki Search is blank, the second part will always be true and the filter will depend only on Wiki Filter. If both are blank, the result will always be true.

[Dutch_Douglas_Byrd]

@Felipe_Arnhold ,

This is definitely a simplified version that works just as well. Thank you for helping to streamline my formula!