Clear an exception from a table list?

gsofo — Fri, 01 Oct 2021 21:04:23 GMT

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.

Customer	Product	Price	Discount	Total	Expected Price	Difference
555	Apple	1		1	1	0
556	Orange	1		1	0.75	-0.25
557	Apple	1	0.5	0.5	1	0
558	Banana	0.25		0.25	0.25	0
559	Banana	0.25		0.25	0.25	0
560	Orange	0.75		0.75	0.75	0
561	Orange	0.75	0.5	0.25	0.75	0
562	Banana	0.5		0.5	0.25	-0.25

topic Clear an exception from a table list? in App Development

Clear an exception from a table list?