Forum Discussion

GwenPeters's avatar
GwenPeters
Qrew Member
6 years ago

Changing Field Color Based on Checked Box

I have a set of date fields that I would like to change the background color once a box is checked indicating that the task is complete.  Would love some help with this if it's possible. Thank you!...
Formulas and functions
AdamKeever1's avatar
AdamKeever1
Qrew Commander
6 years ago
You could use a formula rich text field:

If([checkbox1]=true,
"<span style=background-color:#00ff00;><b>"&ToText([field4])&"</b></span>",
ToText([field4]))

Unchecked:

Checked:

You can use dynamic form rules to show/hide the original date field and include an edit checkbox so the user can change the date field if needed:


Date field is blank:

Date field is not blank:

Date field is not blank AND checkbox is checked:

Date field is not blank AND checkbox is checked and Edit is checked:





------------------------------
Adam Keever
------------------------------
GwenPeters's avatar
GwenPeters
Qrew Member
6 years ago
Thank you Adam. I will try this tomorrow and let you know if any of the options work.  

I am a new QB user and truly appreciate the support!

-g

------------------------------
Gwen Peters
------------------------------