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