Forum Discussion

LisaHudson's avatar
LisaHudson
Qrew Member
5 years ago

Color coding rows in a report based on a fields history

​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
------------------------------
Formulas and functions
Quickbase Automations
reports and charts
  • AustinK's avatar
    AustinK
    Qrew Commander
    5 years ago
    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.