Forum Discussion

TresaTearpak's avatar
TresaTearpak
Qrew Member
7 years ago

populate and color the value of a FORMULA RICH TEXT field based on the values of two other fields

Hello: I have created an input form that has some fields that will be used as look up fields for an end user report.  Fields: CLIENT: Related table within the larger app.  Will be a required f...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
You should be able to use this formula to calculate [Status.Report]


var text Result = 
IF([LEADER.SELECT]="LEADER A" AND [STATUS.SELECT]="IN PROGRESS",  "LEADER A");

"<div style=\"background-color:green;\">"& $Result & "</div>"

In the place of green you can use a hex colour code including the leading #.  There is a great list of colours here

https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=1