3 Replies Latest reply on Oct 20, 2011 7:10 AM by PedroMarroquin

    Can I change the color of a field based of a calculation?

    PedroMarroquin

      Title

      Can I change the color of a field based of a calculation?

      Post

      The thing is this:

       

      Total Paid Debt Status
      $ 20 $ 5 $ 15  

       I have that fields the total field is from an invoice table is a related field, the paid field is a normal field and the debt field is a calculation field, I want that a filed that: if debt field =0 "PAID" but! in green color! and if debt ≠0 "DEBT", BUT IN red color. how can i do that?

       

      Using Filemaker Pro Advanced 11...

      filemaker_questions.jpg