2 Replies Latest reply on Mar 13, 2017 2:49 PM by keywords

    How to find field with a specific color


      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