Inventory with uptdates

[AlecciGSheet]

Hi, i want to make a simple inventory app.

The app consists in that i will have to scan a barcode from a medical device and put that code into an excel specific column and add a state for that code on a right column but in the same row, for example "entered". Then if i read the same code with my phone, the app will detect it and only enable a state change but it will not add the serial number again on the list, so there will be no duplicated serial numbers on the column.

Is that even possible in AppSheet?

Thanks!