Discussions

Expand all | Collapse all

Hightlight a record in a table using status and due date

STEPHANIE MILBURN07-28-2017 15:48

Chuck Grigsby07-28-2017 15:48

  • 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
    https://login.quickbase.com/user-assi...


  • 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

    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", "")

    Thanks for all your help


  • 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