Can I change the color of a field based of a calculation?
The thing is this:
|$ 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...