Discussions

 View Only
  • 1.  Color coding rows in a report based on a fields history

    Posted 08-07-2020 15:35
    ​I want to Color a row on a report based upon a fields history.
    1. For example, field STATUS - if a QB was ever had a status of "REJECTED" then make it a color
    2. Field "Assigned To" - if a QB was assigned to "Development" changed to someone else then Reassigned back to "Development"  then make it a color

    Thank you.

    ------------------------------
    Lisa Hudson
    ------------------------------


  • 2.  RE: Color coding rows in a report based on a fields history

    Posted 08-07-2020 15:46
    If you make a table for logging edits to another table or field when the status changes for related records then you could have logic on there to tell you if a record has ever been in the status of Rejected.

    This is an older post that talks about how to do with with Actions but you can do it with Automations as well. Post #13 explains one way, there are multiple ways posted in this thread though. https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=2e150c68-3266-49e2-b871-af34807f0535&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer

    Without the above table I don't believe you can do this because the record is only ever in one state of status. Same thing for your Assigned To field, you will need to have a running log of that changes to that field that are related to that record. ​

    Once your log table was up and running you could create some summary fields that will tell you if any log record related to the record you are on has ever had a status of Rejected and you can use that in a formula to colorize the report at the bottom.