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
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
------------------------------
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
------------------------------
This is an optional step to take a look at and see how you like it. It does go against your initial desire of seeing the red if you're editing the record:
As long as you're using a legacy form this should work**- Go to a random record on your table and right click on your [Verified] field and select edit the properties of this form element
- select your [verified] field and on the right where it says Display when this form is used for: choose view
- now select the field named [Verified (mirror html)] and on the right where it says Display when this form is used for: choose edit or add
This way both fields won't be visible at the same time. It'll probably look better, but that will be determined by you and your desire for that form. Just throwing it out there.
I also didn't have coding experience other than SQL prior to learning and becoming an admin for Quickbase about a year ago. When I first got access to QB i created an app that only I could see and just played. I practiced adding tables, relationships, formula queries, html, coding pages, api's, everything I saw I tried to duplicate.I also would strongly suggest watching every one of Quickbase Junkie's videos. I attest a lot of my success and understanding as it relates to QB from her. (https://www.youtube.com/c/QuickBaseJunkie)
Discussion boards and this community are a huge help as well. I'd say just google "quickbase html formula", dig through discussions just like we're having here, try to replicate what they're saying and you'll pick it up pretty fast. Also, I constantly reference HTML, SQL, API's, Pipelines, Jinja2 all the time. I don't have much of it memorized, I just understand how and where to find the answer
------------------------------
Shane Miller
------------------------------Hello Shane,
Thank you for the help. I have looked at and downloaded resources from QBJunkie. I'll look into recreating things from the exchange and see how that goes. I need to practice more with jinja, HTMl, pipelines and API's as I believe that as I can learn more we could gain more use out of QB. Thanks again.
-Bart
------------------------------
Alex Bartholomew
------------------------------Happy learning!
Cheers!
-Shane
------------------------------
Shane Miller
------------------------------