Document Status Colors and Reporting
Hi! An old company I worked for used Quickbase years ago and I'm trying to replicate something they did with documents. Can someone help me achieve the need below?
Process need: When we upload fi...
Forum Discussion
I should have added - I needed the "Uploaded" and "Status" for EACH document to be able to use these fields for reporting in other tables.
Also, I solved my own problem - but if anyone runs into a similar issue, I will leave this thread here.
Solution: I added a general "Document Status" Formula - Rich Text field to use as a column in reporting on all doc statuses:
If(IsNull([Date Created]), "<div align=\"center\"><img src=\"https://images.quickbase.com/si/16/226-rect_gray.png\"></div>",
If(([Approved] = false and [Rejected] = false), "<div align=\"center\"><img src=\"https://images.quickbase.com/si/16/229-rect_yellow.png\"></div>",
If([Approved] = true, "<div align=\"center\"><img src=\"https://images.quickbase.com/si/16/228-rect_green.png\"></div>",
If([Rejected] = true, "<div align=\"center\"><img src=\"https://images.quickbase.com/si/16/227-rect_red.png\"></div>"))))
------------------------------
Rikki Ryan
------------------------------