Forum Discussion
Is this what you're looking for?
https://helpv2.quickbase.com/hc/en-us/articles/4570255561108-Color-coding-fields
------------------------------
Shane Miller
------------------------------
- AlexBartholomew2 years agoQrew Member
Hello Shane,
I did see that but do not know how to write the HTML for a blank value. It also seems like I have to make a new field Formula Rich field. How would I reflect the color in the "Verified" field?
------------------------------
Alex Bartholomew
------------------------------- ShaneMiller12 years agoQrew Cadet
Good question.
You are correct in the fact that you have to create a new formula rich field which will essentially mirror your "verified" field.
For simplicity sake, let's say your two fields are:
1) Verified - text field?
2) Verified (mirror html) - formula rich text field
place the following inside the formula box within the Verified (mirror html) properties:If([Verified]="", "<div style=\"color:#DB4437;\"align=\"center\">"& [Verified] &"</div>", [Verified])
//this code essentially says if the [Verified] field is blank, then color code this field with a red background, otherwise if it is not blank just mirror the [Verified] field. To change the background color of this field, simply replace the hex color code "#DB4437" with a hex color code of your choosing
Try this and let me know if it works. If it does, there is one more step to ensure you have a fluid form
------------------------------
Shane Miller
------------------------------- AlexBartholomew2 years agoQrew Member
Hello Shane,
Thank you for the HTML code. The "Verified" field is a date field. With the code you gave me it will not work having the If([Verified] = gives me the error. Would it work if we used IsNull or > or <, then the " "?
Thank you,
Bart
------------------------------
Alex Bartholomew
------------------------------