Understood. That worked, thank you. That color page is also very helpful.
Original Message:
Sent: 03-15-2023 09:39
From: Mark Shnier (Your Quickbase Coach)
Subject: Corrected formula coding in Color-Coding
OK, sorry I didn't originally understand that you wanted to check for three different situation and colour code accordingly.
IF(
[Follow-Up] = "Check on Inspection","#5e9dff",
[Follow-Up] ="Waiting on email response","#aff5f1",
Today() > [Adj. By], "#FF0000")
You have to consider the sequence of the tests above because it will go with the first one that is true.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 03-15-2023 09:22
From: Rhonda Jones
Subject: Corrected formula coding in Color-Coding
So like this?
Case([Follow-Up],"Check on Inspection","#5e9dff", "Waiting on email response","#aff5f1")
IF(Today() > [Adj. By], "#FF0000")
It is giving me the "extra characters beyond the end of the formula"
------------------------------
Rhonda Jones
Original Message:
Sent: 03-15-2023 09:15
From: Mark Shnier (Your Quickbase Coach)
Subject: Corrected formula coding in Color-Coding
Try this
IF(Today() > [Adj. By], "#FF0000")
Laura Thacker, made a nice app here https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=-1000009&dr=1 with all the hex color codes but you can also use many of the color name works like blue, green, pink etc.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 03-15-2023 09:12
From: Rhonda Jones
Subject: Corrected formula coding in Color-Coding
I am trying to highlight the whole row on the table
------------------------------
Rhonda Jones
Original Message:
Sent: 03-15-2023 09:09
From: Mark Shnier (Your Quickbase Coach)
Subject: Corrected formula coding in Color-Coding
Are you trying to highlight a whole row with Row colorization, or are you trying to highlight a single field in a report?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 03-15-2023 08:28
From: Rhonda Jones
Subject: Corrected formula coding in Color-Coding
I currently have this code
Case([Follow-Up],"Check on Inspection","#7FE2EA", "Waiting on email response","#f69100")
and I wanted to add a code to highlight a record based on a date field. I tried both of these and they are not correct. Can anyone assist me with how this field should be formatted?
If(Today() > [Adj. By], "<span style='background-color: #FF0000;'>" & [Record ID#] & "</span>", [Record ID#])
Case(
Today() > [Adj. By],
"<span style='background-color: #FF0000;'>" & [Record ID#] & "</span>",
[Record ID#]
)
Thank you!
------------------------------
Rhonda Jones
------------------------------