How do you set the colour of the content of a field?
What I am trying to achieve is to set the colour to black if a different field reads "Paid" but change it to red if the date it contains is past the current date and the other field is "Unpaid".
The intitial content is created by an If statement that places a future date into it based on the creation date.
I have already used the conditional element of the field to change its colour to red based on comparing the resulting date against the current date.
As this action only needs doing some time after the creation date I am unsure as to what to do, should I use a trigger script that uses the current date then looks for any record that has "Paid" in to make sure the content of a different field is "Black"
Thanks in advance