Inventory Scan Update, Possible?

[kennebel]

Ideal scenario:

1. Have an input screen
2. Scan bar code in to a field (this already works with a hand held scanner or the camera QR option)
3. It reads if the number has changed since the last input, if it has, resets that row ID count field to 1, if not new, +1 to the count field value
4. Waits for next input

(basically, you just click the scanner on each physical thing's bar code, and if there is more than one, it auto-counts them, you just have to do them in order, no jumping around)

I know how I would do this in a traditional app, the code etc., but in appsheet, not sure if I have the access to even put in this simple logic. Open to suggestions on where I can look to have a simple logic input form.