Forum Discussion

BradLemke's avatar
BradLemke
Qrew Assistant Captain
6 years ago

Color Coding a report that is displayed in a form to indicate which workorder you're currently in.

Scenario:  In my [WorkOrders] table, I am tracking deliveries to addresses as well as managing the various projects that these deliveries are for.  There are times where I make multiple deliveries to ...
App builders
Forms
reports and charts
WladimirLlanos's avatar
WladimirLlanos
Qrew Member
6 years ago
Yo can create a rich text formula:
if(condition,"<CENTER><div style=\"color:white; background-color:blue;\">"& " blue" &"</div></CENTER>","<CENTER><div style=\"color:white; background-color:green;\">"& "Other Color" &"</div></CENTER>")

Or, simply you can use Color-Coding option in the report settings. All is up to you.