Re: Color coding rows in a report based on a fields history
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.
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.