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

    How to find field with a specific color

    orlandosardaro

      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