Check in - Check Out items trough QR

[MH_amoblamiento]

Hello to the community!
I developed an app that manages the stock, which is stored in the excel sheet called “Products”, and the intention I have is the following:
In the app you can create orders, with different products (each one has a unique ID) and the idea is that the user can check in / check out the products by scanning a qr. And finally (through some conditional and probably in the form view) tell the user if the order was delivered satisfactorily or not.

[Steve]

Do you have a question?

[MH_amoblamiento]

My question is, which is the most efficient method. My first idea is, create a form view where the user scans products and excel compare with the original order or create some virtual colomn that evaluates that situation (here, i need some formula to achieve it) and shows to the user some alert/information if the order is complete or not. I show you both sheets, hope i was clear enough

[Steve]

In general, any solution that involves spreadsheet expressions will be less efficient than a solution that is done entirely within the app. There are lots of exceptions, but best to start with a solution within the app.