Forum Discussion
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
------------------------------
- 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
------------------------------- ShaneMiller12 years agoQrew Cadet
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
------------------------------- AlexBartholomew2 years agoQrew Member
Hello Shane,
That does work and I am able to put the formula-rich field next to the date field. I have one other question or ask. How or what is the best way to learn how to write HTML? I have been our QuickBase admin for over two years and have learned as I go with no background in computers or coding. If you have any suggestions I would truly appreciate it. Also thank you for taking the time to help me come to a conclusion. Have a great day.
Thank you,
Bart
------------------------------
Alex Bartholomew
------------------------------