We have an Excel spreadsheet that is displayed on 60" screen in our lab to track our repair process. We want to create something better so the customer service people do not need to walk to the lab and type the information needed.
We have some parts of the information in the Notes Database (WO#, date received, date approved, shipped date) and we're thinking to integrate this in the Notes database. We're thinking to create a new form and just use Notes View to display it in Excel like format and from that idea comes the very first question: Is it possible to involve colors in Lotus Notes VIew? If you look at the attachment, the PO column (8th from the left) can have 3 different colors that show different states: red, blue, and white (not shown). Is it possible to do that in Lotus Notes view?
The main goal is to create a Notes app that matches as close as possible with the image attached. Thanks