Highlight Date fields that are blank.
Hello Everyone,
I have been trying to research if it's possible to highlight an existing date field in red if that field is already blank. I have updated my form to now require that field to be fil...
Forum Discussion
Is this what you're looking for?
https://helpv2.quickbase.com/hc/en-us/articles/4570255561108-Color-coding-fields
------------------------------
Shane Miller
------------------------------
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
------------------------------
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
------------------------------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
------------------------------Yes, with dates we need to annotate the blank value differently:
If(IsNull([Verified]), "<div style=\"background-color:#DB4437;color:#DB4437;\"align=\"center\">"& "_" &"</div>", ToText([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
------------------------------
Shane Miller
------------------------------