Discussions

View Only

Hightlight a record in a table using status and due date

• 1.  Hightlight a record in a table using status and due date

Posted 07-28-2017 15:40
Highlighting a record in a table.  I want to highlight a record when a status is not equal to complete and the the due date is today or past.

• 2.  RE: Hightlight a record in a table using status and due date

Posted 07-28-2017 15:48
Report.

• 3.  RE: Hightlight a record in a table using status and due date

Bronze
Contributor
Posted 07-28-2017 15:48
Do you want this on a report or a form?

• 4.  RE: Hightlight a record in a table using status and due date

Bronze
Contributor
Posted 07-28-2017 15:50
Go to the report settings. Should be at the bottom

• 5.  RE: Hightlight a record in a table using status and due date

Posted 07-28-2017 15:54
Yeah I get where to do it. I need to know how to build the formula.

• 6.  RE: Hightlight a record in a table using status and due date

Bronze
Contributor
Posted 07-28-2017 15:58
if ([Status] = "In Progress" and [Due Date] < Today(), "red", "")

The way it works is like this
IF("CONDITION" , "Result if True", "Result if False")

can also use  hex colors, black is #00000 for example.

• 7.  RE: Hightlight a record in a table using status and due date

Posted 07-28-2017 16:00
Chuck, thanks what if its if status does not equal and due date

• 8.  RE: Hightlight a record in a table using status and due date

Posted 07-28-2017 16:01
I ask because I have five statuses and we don't want to highlight the completed records

• 9.  RE: Hightlight a record in a table using status and due date

Bronze
Contributor
Posted 07-28-2017 16:03
you would use != for NOT EQUAL TO

• 10.  RE: Hightlight a record in a table using status and due date

Top
Contributor
Posted 07-28-2017 16:05
Not equal is <> in Quick Base.

News to me if != also works.

• 11.  RE: Hightlight a record in a table using status and due date

Bronze
Contributor
Posted 07-28-2017 16:09
You're right, javascript is !=, quickbase uses <>

• 12.  RE: Hightlight a record in a table using status and due date

Posted 07-28-2017 16:42
Now, I am receiving this message, "The expression [Process Due Date] on the left hand side of the operator "<>" is of type date while the expression "Green" on the right hand side is of type text. The operator "<>" cannot be used with these types of expressions."_

• 13.  RE: Hightlight a record in a table using status and due date

Bronze
Contributor
Posted 07-28-2017 17:00
Could you paste your formula? Sounds like a syntax issue, Green should be after the condition, separated by a comma. Like [Process Due Date] < Today(), "Green

• 14.  RE: Hightlight a record in a table using status and due date

Posted 07-28-2017 17:02
I fixed it; but this is the formula: If ([REC Status] <> "Green" and [Process Due Date] < Today(), "orange", "")

• 15.  RE: Hightlight a record in a table using status and due date

Bronze
Contributor
Posted 07-28-2017 17:03
Awesome! Glad you got it working!

• 16.  RE: Hightlight a record in a table using status and due date

Posted 07-28-2017 17:03
Technically the formula is acceptable but I don't want the Green projects highlighted at all are they are