Contains - Item x AND (item Y OR Item Z) in coda language

[Patricia_Hoffmann]

Hi!

I want to apply a filter to a table, but I’m missing the right formula. Can anyone help?
What I want:
I only want to see items of a table where itemX = checked. In addition, I only want to see items that contain Y OR Z. So basically, itemX= checked always has to be true and from that selection I want coda to only show me the rows that contain either Y or Z.

What’s the right filter formula for that?

[Pch]

Hi @Patricia_Hoffmann !

Maybe this could work :

thisRow.X AND thisRow.Items.Contains(Y,Z)

where :

• The condition 1 is: thisRow.X
  • It returns true if the checkbox X is checked

and

• The condition 2 is: thisRow.Items.Contains(Y,Z)
  • It returns true if the value in the field Items contains either Y or Z

And for the filter to returns one or more rows, both conditions needs to be true (as I used AND)

Here’s a sample to illustrate .

The filter formula has been applied on the [View of Table] so you’ll be able to see the differences between the unfiltered source table called Table (where the results of the filter are highlighted through conditional formatting) and the actual filtered view.

I hope this helps

[Patricia_Hoffmann]

Thank you so much!! It helped a lot

[Pch]

My pleasure @Patricia_Hoffmann !

And I’m very glad to know this helped you moving forward !