AnsweredAssumed Answered

How to find field with a specific color

Question asked by orlandosardaro on Mar 13, 2017
Latest reply on Mar 13, 2017 by keywords

Dear all,

 

I am new to this forum yet have many years of Filemaker Pro experience. One thing though I cannot tackle and I am afraid it is not possible:

 

How can I find records with a specific field in the color NOT black?

 

The background is that I used to de-activate records by coloring a fields text grey. But now, many records later I have added a field "Active" that can have the value 'yes' or 'no.' I now want to set this field to no for the records that I de-activated..

 

I have tried something like

 

Case ( TextColor ( Field = ( RGB ( 0 ; 0 ; 0 ) ) ; "yes" ; "no" )

 

But it doesn't do the trick ;-(

 

Any help will be highly appreciated!

 

Thanks, Orlando

Outcomes