I'm trying to emulate functionality from Excel in Filemaker.
I have a simple table with one boolean field. I seek to have a field of 1 or 0 trigger a "color chip" that will be painted green or red.
Conditional formatting. Set the default color of the text then use a formula to set the field to the other color.
Retrieving data ...