AnsweredAssumed Answered

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

Question asked by PedroMarroquin on Oct 20, 2011
Latest reply on Oct 20, 2011 by 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

Outcomes