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!