I want to insert a red "L" or a green "W" into a field using a script. The field is formatted for black. I have tried to copy and paste using another field formatted green or red, but it doesn't work.
Set field script step with a calculation including textcolor(text;rgb(red;green;blue)).
My current script is:
If field 20 = field Winner
Insert W into 20
I can change it to copy field W and put a W in the field to be pasted.
Are you saying instead of "Insert W into 20" use "Insert Calculated Result"?
I Would use set field instead of insert.
if field 20= "winner"
set field targetField textcolor("w";rgb(0;50;0))
else if field 20="Loser"
set field targetField textcolor("l";rgb(50;0;0))
There's a basic principle in data representation, which transcends the instrument we use to handle the information bits - in our case Filemaker.
The principle is: don't ever, ever change the original data.
Retrieving data ...