I have an audit app. My users are spread across 3 plants and choose parts depending on the plant they are auditing. In a perfect world, they would be auditing random part numbers before they ship.
I have created a view where users can see which parts have been recently audited (to hopefully select a new, un-audited part), the most recent date, AND how many times that part has been audited. It also notes the number of occurrences a part has been a part of an issue within the audit. (This allows an auditor to check on the part again to ensure corrective action to prevent issue has been instituted properly.)
Would there be a way to “shorten” said part numbers if it was to meet certain criteria?
For instance, if part has been chosen recently OR if part number has been chosen more than twice AND part number has not had a recent issue, then “remove” it from the reference list.
Any suggestions how to do so?