I'm curious if something like this is possible, it may not be
We have an app that tracks products sold and the price they were sold at. However, it is a manual process where the users enter in the product, price, and any discount. However, a user could select the wrong product ID but put the correct price in. We'd like a way to clear those out. The product name can't be fixed in the database.
For example, the prices are: Apple $1 Orange $0.75 Banana $0.25
Let's say the second entry in the table below the user selected the wrong product of Orange but put in the correct price for the item which is $1 for an Apple. Would there be a way to have an extra column somewhere where a supervisor who is reviewing these can "clear" it from the list. We could create an Excel file to hold exceptions and remove them that way but I'd like a more automated and clean solution.
In other words, I want the supervisors reviewing the list to be able to clear them without us developers having to code around them.