Table Filter Not Working

[Alyssa_Gono]

I created a selector filter for the table ‘Auto-CodeBook’ labeled ‘Review Status’ and named ‘Auto-Juris View Review Status Selector’

The selector filter value must be equal to the column ‘Reviewed Entry’ value of the table.

thisRow.[Reviewed Entry]==[Auto-Juris View Review Status Selector]

The formula above is what I used for filtering rows., but it doesnt work.

It seems like ‘thisRow.[Reviewed Entry]’ is returning a single value and ‘[Auto-Juris View Review Status Selector]’ is returning a list of options that is why it does filter correctly. How to fix it ?
I have to get the current value of the select dopdown.

[Rickard_Abraham]

I didn’t know you could use two equal signs in coda, I always use one. Maybe try that?

[Alyssa_Gono]

I tried that as well, but it did not work. The problem is Auto-Juris View Review Status Selector returns a list of options, not the current value of the dropdown.

[Pch]

Hi @Alyssa_Gono !

Have you tried to use Matches() ?

Something like :

thisRow.[Reviewed Entry].Matches([Auto-Juris View Review Status Selector])

Matches() exists specifically to easily compare a value from a canvas control to something else …

I’m not sure how the text values in your canvas select control will be interpreted by Coda though as you’re comparing a boolean (thisRow.[Reviewed Entry]) to a text value ( [Auto-Juris View Review Status Selector]) apparently …